Sail E0 Webinar

MCQs

Total Questions : 46 | Page 2 of 5 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.    Each relation has a unique name.
  4.    The order of the columns is significant.
 Discuss Question
Answer: Option C. -> Each relation has a unique name.
Question 12. When mapping a regular entity into a relation which of the following is true?
  1.    One relation is created.
  2.    Two relations are created.
  3.    Three relations are created.
  4.    Four relations are created.
 Discuss Question
Answer: Option A. -> 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.    One relation is created.
  2.    Two relations are created.
  3.    Three relations are created.
  4.    Four relations are created.
 Discuss Question
Answer: Option D. -> Four relations are created.
Question 14. Relations are:
  1.    two-dimensional tables.
  2.    three-dimensional tables.
  3.    four-dimensional tables.
  4.    five-dimensional tables.
 Discuss Question
Answer: Option A. -> two-dimensional tables.
Question 15. When mapping a supertype/subtype relationship which of the following is true?
  1.    The supertype primary key is assigned to each subtype.
  2.    The subtype primary key is assigned to each supertype.
  3.    There is no link between the supertype/subtype entities.
  4.    There is no primary key/foreign key relationship between a supertype/subtype.
 Discuss Question
Answer: Option A. -> The supertype primary key is assigned to each subtype.
Question 16. 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 17. A composite attribute does not get mapped into a relation.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 18. A relation is a two-dimensional table.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 19. Weak entities do not get mapped into a relation.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 20. A primary key may be null.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False

Latest Videos

Latest Test Papers