91. | A foreign key is: |
a. | a column containing the primary key of another table. |
b. | used to define data types. |
c. | used to define null status. |
d. | all of the above are above correct. |
View Answer Report Discuss Too Difficult! |
Answer: (a).a column containing the primary key of another table.
|
92. | Which of the following columns is(are) are required in a table? |
a. | A foreign key |
b. | An alternate key |
c. | A primary key |
d. | A surrogate key. |
View Answer Report Discuss Too Difficult! |
Answer: (c).A primary key
|
93. | In a 1:1 relationship, the foreign key is placed in: |
a. | either table without specifying parent and child tables. |
b. | the parent table. |
c. | the child table. |
d. | either the parent table or the child table. |
View Answer Report Discuss Too Difficult! |
Answer: (a).either table without specifying parent and child tables.
|
94. | Which of the following column properties would be used to specify that cells in a column must be immediately filled with a monetary value of $10,000? |
a. | Null status |
b. | Data type |
c. | Default value |
d. | Data constraints |
View Answer Report Discuss Too Difficult! |
Answer: (c).Default value
|
95. | The identifier of an entity will become the ________ of the new table. |
a. | foreign key |
b. | main attribute |
c. | primary key |
d. | identity key |
View Answer Report Discuss Too Difficult! |
Answer: (c).primary key
|
96. | Which of the following data constraints would be used to specify that the value of a cell in one column must be less than the value of a cell in another column in the same row of the same table? |
a. | A domain constraint |
b. | A range constraint |
c. | An intrarelation constraint |
d. | An interrelation constraint |
View Answer Report Discuss Too Difficult! |
Answer: (c).An intrarelation constraint
|
97. | A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n): |
a. | primary key. |
b. | foreign key. |
c. | composite key. |
d. | surrogate key. |
View Answer Report Discuss Too Difficult! |
Answer: (d).surrogate key.
|
98. | Which is not true about surrogate keys? |
a. | They are short. |
b. | They are fixed. |
c. | They have meaning to the user. |
d. | They are numeric. |
View Answer Report Discuss Too Difficult! |
Answer: (c).They have meaning to the user.
|
99. | For every relationship, how many possible types of actions are there when enforcing minimum cardinalities? |
a. | Two |
b. | Three |
c. | Four |
d. | Six |
View Answer Report Discuss Too Difficult! |
Answer: (d).Six
|
100. | Which constraint requires that the binary relationship indicate all combinations that must appear in the ternary relationship? |
a. | MUST COVER |
b. | MUST NOT |
c. | Both of the above. |
d. | None of the above is correct. |
View Answer Report Discuss Too Difficult! |
Answer: (a).MUST COVER
|