The Relational Model and Normalization – General Questions

11. Table is synonymous with the term:

A. record.
B. relation.
C. column.
D. field.

Correct Answer:  B. relation

12. Which of the following is not a restriction for a table to be a relation?

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.

Correct Answer:  C. The columns must be ordered.

13. For some relations, changing the data can have undesirable consequences called:

A. referential integrity constraints.
B. modification anomalies.
C. normal forms.
D. transitive dependencies.

Correct Answer:  B. modification anomalies.

14. A key:

A. must always be composed of two or more columns.
B. can only be one column.
C. identifies a row.
D. identifies a column.

Correct Answer:  C. identifies a row.

15. An attribute is a(n):

A. column of a table.
B. two dimensional table.
C. row of a table.
D. key of a table.

Correct Answer:  A. column of a table.

Leave A Comment?

fourteen + 12 =