The Relational Model and Normalization - General Questions (2)

9.

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.

10.

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.

11.

A functional dependency is a relationship between or among:

A.	tables.
B.	rows.
C.	relations.
D.	attributes.

Answer: Option D

Explanation:

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

12.

In the relational model, relationships between relations or tables are created by using:

A.	composite keys.
B.	determinants.
C.	candidate keys.
D.	foreign keys.

Answer: Option D

Explanation:

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

13.

A relation is considered a:

A.	Column.
B.	one-dimensional table.
C.	two-dimensional table.
D.	three-dimensional table.

Answer: Option C

Explanation:

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

14.

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):

A.	transitive dependency.
B.	insertion anomaly.
C.	referential integrity constraint.
D.	normal form.

Answer: Option C

Explanation:

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

15.

Which of the following is a group of one or more attributes that uniquely identifies a row?

A.	Key
B.	Determinant
C.	Tuple
D.	Relation

Answer: Option A

Explanation:

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

16.

The primary key is selected from the:

A.	composite keys.
B.	determinants.
C.	candidate keys.
D.	foreign keys.

Answer: Option C

Explanation:

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

1
2
3