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

The Relational Model and Normalization Questions and Answers

61.

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

Answer: B

Correct answer: modification anomalies.

A poorly structured relation makes some changes impossible to perform cleanly: an insertion anomaly prevents a fact being recorded until some unrelated fact is known, a deletion anomaly destroys information as a side effect, and an update anomaly requires the same value to be changed in many places. Normalisation exists to remove them.

Please log in or register to report this question.

62.

In a relation, the order of the columns does not matter.

Answer: A

Correct answer: True

Attributes are identified by name, so writing the columns in a different order produces the same relation. The same is true of rows, which form a set and so have no inherent order either. Both facts follow from the relation being defined by its content rather than by any arrangement of it.

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