Sail E0 Webinar

MCQs

Total Questions : 29 | Page 3 of 3 pages
Question 21. A synonym is two or more attributes that have different names but the same meaning.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 22. Normalization is a formal process for deciding which attributes should be grouped together in a relation.
  1.    False
  2.    True
 Discuss Question
Answer: Option B. -> True
Question 23. The primary key in a relation does not need to be underlined.
  1.    False
  2.    True
 Discuss Question
Answer: Option A. -> False
Question 24. A candidate key must uniquely identify each row.
  1.    False
  2.    True
 Discuss Question
Answer: Option B. -> True
Question 25. In a 1:M relationship, the primary key on the one side migrates to the many side to become the foreign key on the many side.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 26. If a relation is in third normal form, it does not need to be in second normal form.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 27. Well-structured relations encourage anomalies of data.
  1.    False
  2.    True
 Discuss Question
Answer: Option A. -> False
Question 28. A foreign key may be null and still adhere to the referential integrity constraint.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 29. The primary key of the new relation in a many-to-many relationship is a composite key comprised of the primary keys of each of the binary entities.
  1.    False
  2.    True
 Discuss Question
Answer: Option B. -> True

Latest Videos

Latest Test Papers