Data Modeling with ER Model - Database MCQ Questions and answers- Technical Aptitude

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

A. Minimum cardinality

B. Maximum cardinality

C. ERD

D. Greater Entity Count (GEC)

Answer & Solution Discuss in Board Save for Later

2.
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?

A. Weak entity

B. Strong entity

C. ID-dependent entity

D. ID- independent entity

Answer & Solution Discuss in Board Save for Later

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

A. parent

B. child

C. instance

D. subtype

Answer & Solution Discuss in Board Save for Later

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

A. Supertype entity

B. Subtype entity

C. Archetype entity

D. Instance entity

Answer & Solution Discuss in Board Save for Later

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

A. itself

B. a subtype entity

C. an archetype entity

D. an instance entity

Answer & Solution Discuss in Board Save for Later

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

A. Minimum cardinality

B. Maximum cardinality

C. ERD

D. Greater Entity Count (GEC)

Answer & Solution Discuss in Board Save for Later

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

A. Entity

B. Attribute

C. Identifier

D. Relationship

Answer & Solution Discuss in Board Save for Later

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

A. One-to-One Relationship

B. One-to-Many Relationship

C. Many-to-Many Relationship

D. Composite Relationship

Answer & Solution Discuss in Board Save for Later

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

A. Weak entity

B. Strong entity

C. ID-dependent entity

D. ID-independent entity

Answer & Solution Discuss in Board Save for Later

10.
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?

A. Supertype entity

B. Subtype entity

C. Archetype entity

D. Instance entity

Answer & Solution Discuss in Board Save for Later

Data Modeling with ER Model - Database MCQ Questions and answers- Technical Aptitude

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

Answer & Solution

2. 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?

Answer & Solution

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

Answer & Solution

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

Answer & Solution

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

Answer & Solution

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

Answer & Solution

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

Answer & Solution

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

Answer & Solution

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

Answer & Solution

10. 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?

Answer & Solution

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

2.
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?

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

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

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

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

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

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

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

10.
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?