The Relational Model and Normalization problems
- 1. A key:
Options- A. must always be composed of two or more columns.
- B. can only be one column.
- C. identifies a row.
- D. identifies a column. Discuss
Correct Answer: identifies a row.
- 2. An attribute is a(n):
Options- A. column of a table.
- B. two dimensional table.
- C. row of a table.
- D. key of a table. Discuss
Correct Answer: column of a table.
- 3. If attributes A and B determine attribute C, then it is also true that:
Options- A. A ? C.
- B. B ? C.
- C. (A,B) is a composite determinant.
- D. C is a determinant. Discuss
Correct Answer: (A,B) is a composite determinant.
- 4. The primary key is selected from the:
Options- A. composite keys.
- B. determinants.
- C. candidate keys.
- D. foreign keys. Discuss
Correct Answer: candidate keys.
- 5. In the relational model, relationships between relations or tables are created by using:
Options- A. composite keys.
- B. determinants.
- C. candidate keys.
- D. foreign keys. Discuss
Correct Answer: foreign keys.
- 6. Table is synonymous with the term:
Options- A. record.
- B. relation.
- C. column.
- D. field. Discuss
Correct Answer: relation.
- 7. For some relations, changing the data can have undesirable consequences called:
Options- A. referential integrity constraints.
- B. modification anomalies.
- C. normal forms.
- D. transitive dependencies. Discuss
Correct Answer: modification anomalies.
- 8. Which of the following is not a restriction for a table to be a relation?
Options- A. The cells of the table must contain a single value.
- B. All of the entries in any column must be of the same kind.
- C. The columns must be ordered.
- D. No two rows in a table may be identical. Discuss
Correct Answer: The columns must be ordered.
- 9. A functional dependency is a relationship between or among:
Options- A. tables.
- B. rows.
- C. relations.
- D. attributes. Discuss
Correct Answer: attributes.
- 10. When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):
Options- A. transitive dependency.
- B. insertion anomaly.
- C. referential integrity constraint.
- D. normal form. Discuss
Correct Answer: referential integrity constraint.
More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.