The Relational Model and Normalization - Database MCQ Questions and answers- Technical Aptitude

A. record.

B. relation.

C. column.

D. field.

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.

A. referential integrity constraints.

B. modification anomalies.

C. normal forms.

D. transitive dependencies.

A. must always be composed of two or more columns.

B. can only be one column.

C. identifies a row.

D. identifies a column.

A. column of a table.

B. two dimensional table.

C. row of a table.

D. key of a table.

A. First normal form

B. Second normal form

C. Third normal form

D. Domain/key normal form

A. A → C.

B. B → C.

C. (A,B) is a composite determinant.

D. C is a determinant.

A. column of a table.

B. two dimensional table.

C. row of a table.

D. key of a table.

A. A → B.

B. B → A.

C. C → A.

D. (B,C) → A.

A. split the relation into two relations, each with a single theme.

B. change the theme.

C. create a new theme.

D. add a composite key.