Sail E0 Webinar

MCQs

Total Questions : 46 | Page 4 of 5 pages
Question 31.  An action assertion must include which of the following?
  1.    Anchor object
  2.    Action
  3.    Corresponding object
  4.    All of the above.
 Discuss Question
Answer: Option D. -> All of the above.
Question 32.  When an entity instance must be a member of only one subtype, it is which of the following?
  1.    Disjoint with total specialization
  2.    Disjoint with partial specialization
  3.    Overlap with total specialization
  4.    Overlap with partial specialization
 Discuss Question
Answer: Option A. -> Disjoint with total specialization
Question 33.  A supertype/subtype hierarchy is which of the following?
  1.    Each subtype has only one attribute.
  2.    Each supertype has only one attribute.
  3.    Each subtype has only one supertype.
  4.    Each supertype has only one subtype.
 Discuss Question
Answer: Option C. -> Each subtype has only one supertype.
Question 34.  Inheritance is which of the following?
  1.    When a supertype entity inherits values of the subtype attribute
  2.    When a subtype entity inherits values of the supertype attribute
  3.    When a supertype entity inherits values of another supertype attribute
  4.    When a subtype entity inherits values of another subtype attribute
 Discuss Question
Answer: Option B. -> When a subtype entity inherits values of the supertype attribute
Question 35.  An oval represents which of the following in an EER?
  1.    Attribute
  2.    Entity
  3.    Optional One
  4.    Relationship
 Discuss Question
Answer: Option A. -> Attribute
Question 36.  A rectangle represents which of the following in an EER?
  1.    Attribute
  2.    Entity
  3.    Optional One
  4.    Relationship
 Discuss Question
Answer: Option B. -> Entity
Question 37.  Which one of the following symbols is not used in an ERD?
  1.    Rectangle
  2.    Oval
  3.    Diamond
  4.    Circle
 Discuss Question
Answer: Option D. -> Circle
Question 38.  Specialization is which of the following processes?
  1.    Defining one or more subtypes of the supertype and forming supertype/subtype relationships.
  2.    Defining one or more supertypes of the subtype and forming supertype/subtype relationships.
  3.    Defining one or more subtypes of the supertype and not forming supertype/subtype relationships.
  4.    Defining one or more supertypes of the subtype and not forming supertype/subtype relationships.
 Discuss Question
Answer: Option A. -> Defining one or more subtypes of the supertype and forming supertype/subtype relationships.
Question 39.  Which of the following statements concerning business rules is true?
  1.    It should be complex.
  2.    It should not be convertible to computer code.
  3.    It may include restrictions.
  4.    All of the above.
 Discuss Question
Answer: Option C. -> It may include restrictions.
Question 40. . A supertype/subtype hierarchy has which of the following features?
  1.    Subtypes at the lower lever in the hierarchy inherit attributes only from their immediate supertype.
  2.    Attributes are assigned at the highest logical level.
  3.    Subtypes at the higher lever in the hierarchy inherit attributes only from their immediate subtype.
  4.    Attributes are assigned at the lowest logical level.
 Discuss Question
Answer: Option B. -> Attributes are assigned at the highest logical level.

Latest Videos

Latest Test Papers