Vidyalelo
Database · all questions

Data Modeling with ER Model
practice.

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

40

Questions

1/2

Page

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

Which of the following indicates the maximum number of entities that can be involved in a relationship?

Select an option to see the answer and solution.

Which type of entity cannot exist in the database unless another type of entity also exists in the database, but does not require that the identifier of that other entity be included as part of its own identifier?

Select an option to see the answer and solution.

In a one-to-many relationship, the entity that is on the one side of the relationship is called a(n) ________ entity.

Select an option to see the answer and solution.

Which type of entity represents an actual occurrence of an associated generalized entity?

Select an option to see the answer and solution.

A recursive relationship is a relationship between an entity and ________ .

Select an option to see the answer and solution.

Which of the following indicates the minimum number of entities that must be involved in a relationship?

Select an option to see the answer and solution.

Which of the following refers to something that can be identified in the user's work environment, something that the users want to track?

Select an option to see the answer and solution.

In which of the following is a single-entity instance of one type related to many entity instances of another type?

Select an option to see the answer and solution.

Which of the following refers to an entity in which the identifier of one entity includes the identifier of another entity?

Select an option to see the answer and solution.

Which type of entity is related to two or more associated entities that each contain specialized attributes that apply to some but not all of the instances of the entity?

Select an option to see the answer and solution.

An attribute that names or identifies entity instances is a(n):

Select an option to see the answer and solution.

Properties that describe the characteristics of entities are called:

Select an option to see the answer and solution.

In which of the following can many entity instances of one type be related to many entity instances of another type?

Select an option to see the answer and solution.

Entities of a given type are grouped into a(n):

Select an option to see the answer and solution.

Which of the following is NOT a basic element of all versions of the E-R model?

Select an option to see the answer and solution.

In which of the following is a single-entity instance of one type of related to a single-entity instance of another type?

Select an option to see the answer and solution.

Entities can be associated with one another in which of the following?

Select an option to see the answer and solution.

Which type of entity has its relationship to another entity determined by an attribute in that other entity called a discriminator?

Select an option to see the answer and solution.

Which type of entity represents a logical generalization whose actual occurrence is represented by a second, associated entity?

Select an option to see the answer and solution.

In a one-to-many relationship, the entity that is on the many side of the relationship is called a(n) ________ entity.

Select an option to see the answer and solution.