Question

Indicate whether the statement is true or false

Answer 1

FALSE

Answer 2

C

Answer 3

B

Answer 4

A

Answer 5

FALSE

Answer 6

FALSE

Answer 7

FALSE

Answer 8

Ans: (b)

Answer 9

A

Answer 10

There are four popular data integrity control methods: default value, range control, referential integrity, and null value control. A default value is the value a field will assume unless an explicit value is entered for the field. Range control is when both numeric and alphabetic data may have a limited set of permissible values. The most common example of referential integrity is cross-referencing between relations. (The definition of referential integrity is given in a different chapter so the student may use an example). A null value is a special field value, distinct from a zero, blank, or any other value, that indicates that the value for the field is missing or otherwise unknown.

Answer 11

B

Answer 12

B

Answer 13

FALSE

Answer 14

boxes

Answer 15

TRUE

Answer 16

B
Explanation: B) Tools make it easier to use techniques when designing an information system.

Answer 17

A

Answer 18

D

Answer 19

FALSE

Answer 20

In some cases, a query may contain another query (or queries). A query that contains within itself another query (nested query) is called an outer query.

Answer 21

TRUE

Answer 22

Synchronous communications are collaborations where all the team members meet at the same time. Examples include face-to-face meetings, videoconferencing, conference calls, and multiparty chats.
Asynchronous communications occur when team members do not meet at the same time. Emails, discussion forums, and team surveys are examples of asynchronous communication.

Answer 23

FALSE

Answer 24

D

Answer 25

A

Answer 26

B

Answer 27

B

Answer 28

Ans: C) Metadata

Answer 29

To create a switchboard, open a blank form. Add text to the form by using text labels, and add buttons that can trigger database application actions by using command buttons. Command buttons are built using the Command Button Wizard. There are various formatting options for choosing colors and design layout of the switchboard.

Answer 30

C

Answer 31

TRUE

Answer 32

B

Answer 33

TRUE

Answer 34

FALSE

Answer 35

FALSE

Answer 36

A

Answer 37

TRUE

Answer 38

TRUE

Answer 39

To change a table name, we re-create the table with the new name, copy the data to the new table, and finally drop the old table. Although the process is simple, there are several considerations. First is the problem of a surrogate key, for the existing values must be maintained. This is solved by creating the key as regular field, copying the date, and then converting the column to a surrogate key. Second is the problem of restructuring constrains to make sure they now apply to the new table. Finally any stored procedures, triggers and other application code that applied to the old table must be rewritten to apply to the new table.

Answer 40

System dynamics

Answer 41

FALSE

Answer 42

B

Answer 43

FALSE

Answer 44

generalization/ specialization

Answer 45

B

Answer 46

D

Answer 47

human

Answer 48

FALSE

Answer 49

security association bundle

Answer 50

D

Answer 51

C

Answer 52

Answer: True