Sail E0 Webinar

MCQs

Total Questions : 60 | Page 3 of 6 pages
Question 21. In a 1:1 relationship, the primary key placement is arbitrary.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 22. 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 23. Intersection tables are ID-dependent on both their parent tables.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 24. All primary keys are required.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 25. For every relationship, there are six possible sets of minimum cardinalities.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 26. An intersection table is required to represent M:N relationships.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 27. The DBMS allows surrogate keys to be changed.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 28. Cascading updates refers to child rows being automatically deleted when a parent row is deleted.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 29. When transforming an entity-relationship model into a relational database design, each entity is represented as a table.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 30. Surrogate keys have much meaning for users.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False

Latest Videos

Latest Test Papers