Sail E0 Webinar

MCQs

Total Questions : 29 | Page 2 of 3 pages
Question 11. A relation has which of the following properties?
  1.    Each row is not unique.
  2.    Attributes can have the same name within a given table.
  3.    The order of the columns is significant.
  4.    Each relation has a unique name.
 Discuss Question
Answer: Option D. -> Each relation has a unique name.
Question 12. When mapping a regular entity into a relation which of the following is true?
  1.    Three relations are created.
  2.    One relation is created.
  3.    Two relations are created.
  4.    Four relations are created.
 Discuss Question
Answer: Option B. -> One relation is created.
Question 13. When mapping a ternary relationship with an associative entity into a relation which of the following is true?
  1.    Four relations are created.
  2.    One relation is created.
  3.    Two relations are created.
  4.    Three relations are created.
 Discuss Question
Answer: Option A. -> Four relations are created.
Question 14. When mapping a supertype/subtype relationship which of the following is true?
  1.    The subtype primary key is assigned to each supertype.
  2.    There is no primary key/foreign key relationship between a supertype/subtype.
  3.    There is no link between the supertype/subtype entities.
  4.    The supertype primary key is assigned to each subtype.
 Discuss Question
Answer: Option D. -> The supertype primary key is assigned to each subtype.
Question 15. Relations are:
  1.    four-dimensional tables.
  2.    two-dimensional tables.
  3.    three-dimensional tables.
  4.    five-dimensional tables.
 Discuss Question
Answer: Option B. -> two-dimensional tables.
Question 16. A primary key may be null.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 17. Weak entities do not get mapped into a relation.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 18. A composite attribute does not get mapped into a relation.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 19. An enterprise key is a primary key whose value is unique for a given relation.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 20. A null value is assigned when no other value applies.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True

Latest Videos

Latest Test Papers