Sail E0 Webinar

MCQs

Total Questions : 30 | Page 2 of 3 pages
Question 11. A subtype discriminator is which of the following?
  1.    An attribute of the supertype whose values determine the supertype
  2.    An attribute of the supertype whose values determine the subtype
  3.    An attribute of the subtype whose values determine the supertype
  4.    An attribute of the subtype whose values determine the subtype
 Discuss Question
Answer: Option B. -> An attribute of the supertype whose values determine the subtype
Question 12. Which of the following is not one of the three ways to classify an action assertion?
  1.    Enabler
  2.    Integrity Control
  3.    Condition
  4.    Authorization
 Discuss Question
Answer: Option A. -> Enabler
Question 13. Use of a supertype/subtype relationship is necessary when which of the following exists?
  1.    Attributes apply to all of the instances of an entity type.
  2.    An instance of a subtype participates in a relationship that is the same as the other subtypes.
  3.    An instance of a subtype participates in a relationship that is unique to that subtype.
  4.    No attributes apply to any of the instances of an entity type.
 Discuss Question
Answer: Option C. -> An instance of a subtype participates in a relationship that is unique to that subtype.
Question 14. When an entity instance may be a member of multiple subtypes or it does not have to be a member of a subtype, it is which of the following?
  1.    Overlap with partial specialization
  2.    Disjoint with partial specialization
  3.    Overlap with total specialization
  4.    Disjoint with total specialization
 Discuss Question
Answer: Option C. -> Overlap with total specialization
Question 15. A subtype entity name should be which of the following?
  1.    Specific to the organization
  2.    A singular noun
  3.    All of these
  4.    Concise
 Discuss Question
Answer: Option C. -> All of these
Question 16. A subtype discriminator of the supertype is an attribute whose values determine the target subtype(s).
  1.    False
  2.    True
 Discuss Question
Answer: Option B. -> True
Question 17. Packaged data models are meant to be exactly right straight out of the box.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 18. A supertype can only have only one subtype.
  1.    False
  2.    True
 Discuss Question
Answer: Option A. -> False
Question 19. An action assertion is a statement that expresses some aspect of the static structure of the organization.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 20. There is cardinality on an EER between the supertype and subtype.
  1.    False
  2.    True
 Discuss Question
Answer: Option A. -> False

Latest Videos

Latest Test Papers