Sail E0 Webinar

MCQs

Total Questions : 40 | Page 3 of 4 pages
Question 21. The terms alternate key and candidate key mean the same thing.
  1.    False
  2.    True
 Discuss Question
Answer: Option B. -> True
Question 22. When the parent entity is required, cascading updates and cascading deletions should be allowed or the associated actions on the parent should be prohibited.
  1.    False
  2.    True
 Discuss Question
Answer: Option B. -> True
Question 23. A foreign key is used to implement relationships between tables.
  1.    False
  2.    True
 Discuss Question
Answer: Option B. -> True
Question 24. In 1:N relationships, which entity becomes the parent entity is arbitrary.
  1.    False
  2.    True
 Discuss Question
Answer: Option A. -> False
Question 25. In a 1:1 relationship, the primary key placement is arbitrary.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 26. When the parent entity is required, a new child row can always be inserted.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 27. For every relationship, there are six possible sets of minimum cardinalities.
  1.    False
  2.    True
 Discuss Question
Answer: Option A. -> False
Question 28. All primary keys are required.
  1.    False
  2.    True
 Discuss Question
Answer: Option B. -> True
Question 29. Intersection tables are ID-dependent on both their parent tables.
  1.    False
  2.    True
 Discuss Question
Answer: Option B. -> True
Question 30. An intersection table is required to represent M:N relationships.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True

Latest Videos

Latest Test Papers