This set of Advanced Database Management System focuses on “Entity Relationship Diagram MCQs (Multiple Choice Questions and Answers )”.

PRACTICE IT NOW TO SHARPEN YOUR CONCEPT AND KNOWLEDGE

#### 1. An ER diagram can express the overall __________of a database graphically

• View Structure
• Logical Structure
• Model Structure
• Architectural structure

#### 2. Which of the following structure represent the entity sets?

• Double rectangle
• Diamond
• Rectangle
• Ellipses

#### 3. Ellipses represent_________

• Relationship sets
• Attributes
• Derived attributes
• Multivalued attributes

#### 4. Diamond Represents______

• Relationship sets
• Attributes
• Derived attributes
• Multi-valued attributes
• Double lines
• Dashed Ellipses
• Double ellipses
• Lines

#### 6. Double ellipses represents_____

• Derived attributes
• Multi-valued Attributes
• Total participation of an entity in a relationship set
• Weak entity sets

#### 7. Dashed ellipses represents_____

• Derived attributes
• Multi-valued Attributes
• Total participation of an entity in a relationship set
• Weak entity sets

#### 8. Double Line indicate_____

• Derived attributes
• Multi-valued Attributes
• Total participation of an entity in a relationship set
• Weak entity sets

#### 9. Double Rectangle represent_____

• Derived attributes
• Multi-valued Attributes
• Total participation of an entity in a relationship set
• Weak entity sets
• One to one, many to one
• many to many, one to many
• Many to many, one to one
• One to One, Many to Many
• One to one, many to one
• many to many, one to many
• Many to many, one to one
• One to One, Many to Many

#### 12. An Edge between a entity set and a binary relationship set can have an associated minimum and maximum cardinality, shown in the form of l and h, where l is the minimum and h is the maximum cardinality. What a minimum Cardinality value of 1 indicates?

• Partial Participation of the entity set in the relationship
• Total Participation of the entity set in the relationship
• The entity participates in at most one relationship
• No limit on participation

#### 13. An Edge between a entity set and a binary relationship set can have an associated minimum and maximum cardinality, shown in the form of l and h, where l is the minimum and h is the maximum cardinality. What a Maximum Cardinality value of 1 indicates?

• Partial Participation of the entity set in the relationship
• Total Participation of the entity set in the relationship
• The entity participates in at most one relationship
• No limit on participation

#### 14. An Edge between a entity set and a binary relationship set can have an associated minimum and maximum cardinality, shown in the form of l and h, where l is the minimum and h is the maximum cardinality. What a Maximum Cardinality value of * indicates?

• Partial Participation of the entity set in the relationship
• Total Participation of the entity set in the relationship
• The entity participates in at most one relationship
• No limit on participation

#### 15. An entity set may not have sufficient attributes to form a primary key; such an entity set is termed as______

• Strong Entity set
• Weak Entity set
• Composite Entity set
• Owner entity set

#### 16. An entity set that has attributes to form a primary key; such an entity set is termed as______

• Strong Entity set
• Weak Entity set
• Composite Entity set
• Owner entity set

#### 17. For a weak entity set to be meaningful, it must be associated with another entity set called the ___________

• Strong entity set
• stronger entity set
• Owner entity set
• All of the above

Share with :