ER Model and Business Rules – General Questions

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

A. Anchor object
B. Action
C. Corresponding object
D. All of the above.

Correct Answer:  D. All of the above.
Advertisement

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

A. Attribute
B. Entity
C. Optional One
D. Relationship

Correct Answer:  A. Attribute
Advertisement

3. Inheritance is which of the following?

A. When a supertype entity inherits values of the subtype attribute
B. When a subtype entity inherits values of the supertype attribute
C. When a supertype entity inherits values of another supertype attribute
D. When a subtype entity inherits values of another subtype attribute

Correct Answer:  B. When a subtype entity inherits values of the supertype attribute
Advertisement

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

A. Disjoint with total specialization
B. Disjoint with partial specialization
C. Overlap with total specialization
D. Overlap with partial specialization

Correct Answer:  A. Disjoint with total specialization
Advertisement

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

A. Each subtype has only one attribute.
B. Each supertype has only one attribute.
C. Each subtype has only one supertype.
D. Each supertype has only one subtype.

Correct Answer:  C. Each subtype has only one supertype.
Advertisement

Leave A Comment?