Data Models into Database Designs problems
- 1. Which constraint requires that the binary relationship indicate all combinations that must appear in the ternary relationship?
Options- A. MUST COVER
- B. MUST NOT
- C. Both of the above.
- D. None of the above is correct. Discuss
Correct Answer: MUST COVER
- 2. A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n):
Options- A. primary key.
- B. foreign key.
- C. composite key.
- D. surrogate key. Discuss
Correct Answer: surrogate key.
- 3. For every relationship, how many possible sets of minimum cardinalities are there?
Options- A. Two
- B. Three
- C. Four
- D. Six Discuss
Correct Answer: Four
- 4. Which of the following data constraints would be used to specify that the value of cells in a column must be one of a specific set of possible values?
Options- A. A domain constraint
- B. A range constraint
- C. An intrarelation constraint
- D. An interrelation constraint Discuss
Correct Answer: A domain constraint
- 5. A foreign key is:
Options- 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. Discuss
Correct Answer: a column containing the primary key of another table.
- 6. For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?
Options- A. Two
- B. Three
- C. Four
- D. Six Discuss
Correct Answer: Six
- 7. Which of the following column properties specifies whether or not cells in a column must contain a data value?
Options- A. Null status
- B. Data type
- C. Default value
- D. Data constraints Discuss
Correct Answer: Null status
- 8. Which of the following column properties would be used to specify that cells in a column must contain a monetary value that is less than another monetary value in the same row?
Options- A. Null status
- B. Data type
- C. Default value
- D. Data constraints Discuss
Correct Answer: Data constraints
- 9. Which of the following columns is(are) are required in a table?
Options- A. A foreign key
- B. An alternate key
- C. A primary key
- D. A surrogate key. Discuss
Correct Answer: A primary key
- 10. Which is not true about surrogate keys?
Options- A. They are short.
- B. They are fixed.
- C. They have meaning to the user.
- D. They are numeric. Discuss
Correct Answer: They have meaning to the user.
More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.