Database - The Relational Model and Normalization

Exercise :: The Relational Model and Normalization - General Questions

11. 

Table is synonymous with the term:

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

Answer: Option B

Explanation:

No answer description available for this question. Let us discuss.

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.

Answer: Option C

Explanation:

No answer description available for this question. Let us discuss.

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.

Answer: Option B

Explanation:

No answer description available for this question. Let us discuss.

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.

Answer: Option C

Explanation:

No answer description available for this question. Let us discuss.

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.

Answer: Option A

Explanation:

No answer description available for this question. Let us discuss.