Machine-translated by Google. Questions are authored in English.
Top

The Relational Model and Normalization Questions and Answers

91.

In a relation, the rows are sometimes called "fields."

Answer: B

Correct answer: False

Rows are tuples, or records; it is the columns that are called fields, along with attributes. Getting the correspondence the wrong way round is easy, so it is worth fixing the two triples in mind: relation, table, file for the whole structure; tuple, row, record across; and attribute, column, field down.

Please log in or register to report this question.

92.

A primary key is a composite key that was selected to be the main identifier for the relation.

Answer: B

Correct answer: False

A primary key is chosen from among the candidate keys, and there is no requirement that it be composite - most primary keys are single attributes, and many are deliberately introduced surrogate keys for exactly that reason. A composite key may be selected as the primary key, but that is a possibility rather than part of the definition.

Please log in or register to report this question.

Loading…

Other Subjects

Tags: The Relational Model and Normalization Questions and Answers || The Relational Model and Normalization MCQ Questions and Answers || The Relational Model and Normalization GK Questions and Answers || The Relational Model and Normalization GK MCQ Questions || The Relational Model and Normalization Multiple Choice Questions and Answers || The Relational Model and Normalization GK || GK on The Relational Model and Normalization || Database Questions and Answers || Database MCQ Questions and Answers || Database GK Questions and Answers || GK on Database