Database MCQ - English

ER Model and Business Rules MCQ Questions and Answers

Home | Database | ER Model and Business Rules

In this section we provide lots of objective question of ER Model and Business Rules in Database Management System.

Page: 1/2

1) An action assertion must include which of the following?

    Anchor object
    Action
    Action
    All of the above

Answer : D Discuss

2) An oval represents which of the following in an EER?

    Attribute
    Entity
    Optional One
    Relationship

Answer : A Discuss

3) Inheritance is which of the following?

    When a supertype entity inherits values of the subtype attribute
    When a subtype entity inherits values of the supertype attribute
    When a supertype entity inherits values of another supertype attribute
    When a subtype entity inherits values of another subtype attribute

Answer : B Discuss

4) When an entity instance must be a member of only one subtype, it is which of the following?

    Disjoint with total specialization
    Disjoint with partial specialization
    Overlap with total specialization
    Overlap with partial specialization

Answer : A Discuss

5) A supertype/subtype hierarchy is which of the following?

    Each subtype has only one attribute.
    Each supertype has only one attribute.
    Each subtype has only one supertype.
    Each supertype has only one subtype.

Answer : C Discuss

6) A rectangle represents which of the following in an EER?

    Attribute
    Entity
    Optional One
    Relationship

Answer : B Discuss

7) Which one of the following symbols is not used in an ERD?

    Rectangle
    Oval
    Diamond
    Circle

Answer : D Discuss

8) Specialization is which of the following processes?

    Defining one or more subtypes of the supertype and forming supertype/subtype relationships.
    Defining one or more supertypes of the subtype and forming supertype/subtype relationships.
    Defining one or more subtypes of the supertype and not forming supertype/subtype relationships.
    Defining one or more supertypes of the subtype and not forming supertype/subtype relationships.

Answer : A Discuss

9) Which of the following statements concerning business rules is true?

    It should be complex.
    It should not be convertible to computer code.
    It may include restrictions.
    All of the above.

Answer : C Discuss

10) A supertype/subtype hierarchy has which of the following features?

    Subtypes at the lower lever in the hierarchy inherit attributes only from their immediate supertype.
    Attributes are assigned at the highest logical level.
    Subtypes at the higher lever in the hierarchy inherit attributes only from their immediate subtype.
    Attributes are assigned at the lowest logical level.

Answer : B Discuss

Jump to Pages:

1 2

MCQ Category