Sail E0 Webinar

MCQs

Total Questions : 30 | Page 1 of 3 pages
Question 1. An action assertion must include which of the following?
  1.    All of these
  2.    Anchor object
  3.    Action
  4.    Corresponding object
 Discuss Question
Answer: Option A. -> All of these
Question 2. When an entity instance must be a member of only one subtype, it is which of the following?
  1.    Overlap with total specialization
  2.    Disjoint with total specialization
  3.    Disjoint with partial specialization
  4.    Overlap with partial specialization
 Discuss Question
Answer: Option B. -> Disjoint with total specialization
Question 3. Inheritance is which of the following?
  1.    When a subtype entity inherits values of another subtype attribute
  2.    When a supertype entity inherits values of the subtype attribute
  3.    When a supertype entity inherits values of another supertype attribute
  4.    When a subtype entity inherits values of the supertype attribute
 Discuss Question
Answer: Option D. -> When a subtype entity inherits values of the supertype attribute
Question 4. A supertype/subtype hierarchy is which of the following?
  1.    Each supertype has only one subtype.
  2.    Each supertype has only one attribute.
  3.    Each subtype has only one supertype.
  4.    Each subtype has only one attribute.
 Discuss Question
Answer: Option C. -> Each subtype has only one supertype.
Question 5. An oval represents which of the following in an EER?
  1.    Optional One
  2.    Entity
  3.    Relationship
  4.    Attribute
 Discuss Question
Answer: Option D. -> Attribute
Question 6. A rectangle represents which of the following in an EER?
  1.    Relationship
  2.    Attribute
  3.    Entity
  4.    Optional One
 Discuss Question
Answer: Option C. -> Entity
Question 7. 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.
Question 8. Which one of the following symbols is not used in an ERD?
  1.    Circle
  2.    Diamond
  3.    Rectangle
  4.    Oval
 Discuss Question
Answer: Option A. -> Circle
Question 9. Which of the following statements concerning business rules is true?
  1.    It should be complex.
  2.    All of these
  3.    It may include restrictions.
  4.    It should not be convertible to computer code.
 Discuss Question
Answer: Option C. -> It may include restrictions.
Question 10. 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 not 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 forming supertype/subtype relationships.
 Discuss Question
Answer: Option A. -> Defining one or more subtypes of the supertype and forming supertype/subtype relationships.

Latest Videos

Latest Test Papers