Sail E0 Webinar

MCQs

Total Questions : 46 | Page 3 of 5 pages
Question 21. A null value is assigned when no other value applies.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 22. The primary key in a relation does not need to be underlined.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 23. 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 24. 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 25. Normalization is a formal process for deciding which attributes should be grouped together in a relation.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 26. A candidate key must uniquely identify each row.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 27. Well-structured relations encourage anomalies of data.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> 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.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 30. 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

Latest Videos

Latest Test Papers