Vidyalelo
Database · all questions

ER Model and Business Rules
practice.

Practice every MCQ with options. Use Show answers when you want the correct option and solution.

30

Questions

1/2

Page

Pick an option on a question to see the right answer and solution.

An action assertion must include which of the following?

Select an option to see the answer and solution.

An oval represents which of the following in an EER?

Select an option to see the answer and solution.

Inheritance is which of the following?

Select an option to see the answer and solution.

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

Select an option to see the answer and solution.

A supertype/subtype hierarchy is which of the following?

Select an option to see the answer and solution.

A rectangle represents which of the following in an EER?

Select an option to see the answer and solution.

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

Select an option to see the answer and solution.

Specialization is which of the following processes?

Select an option to see the answer and solution.

Which of the following statements concerning business rules is true?

Select an option to see the answer and solution.

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

Select an option to see the answer and solution.

A subtype discriminator is which of the following?

Select an option to see the answer and solution.

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?

Select an option to see the answer and solution.

A subtype entity name should be which of the following?

Select an option to see the answer and solution.

Use of a supertype/subtype relationship is necessary when which of the following exists?

Select an option to see the answer and solution.

Which of the following is not one of the three ways to classify an action assertion?

Select an option to see the answer and solution.

Packaged data models are meant to be exactly right straight out of the box.

Select an option to see the answer and solution.

An action assertion is a statement that expresses some aspect of the static structure of the organization.

Select an option to see the answer and solution.

A supertype can only have only one subtype.

Select an option to see the answer and solution.

There is cardinality on an EER between the supertype and subtype.

Select an option to see the answer and solution.

A subtype discriminator of the supertype is an attribute whose values determine the target subtype(s).

Select an option to see the answer and solution.