MCQs on Extended Entity-Relationship (EER) Modeling in DBMS
- What does EER stand for in database modeling?
- a) Enhanced Entity-Relationship
- b) Extended Entity-Relationship
- c) Elaborated Entity-Relationship
- d) Evolved Entity-Relationship
Answer: b) Extended Entity-Relationship
- In EER diagrams, a superclass and its subclasses are connected by which type of symbol?
- a) Rectangle
- b) Ellipse
- c) Diamond
- d) Triangle
Answer: d) Triangle
- Which of the following concepts is not part of the EER model?
- a) Specialization
- b) Generalization
- c) Aggregation
- d) Normalization
Answer: d) Normalization
- In EER modeling, a collection of entities that are specialized into sub-groups based on some distinguishing characteristics is called:
- a) Specialization
- b) Generalization
- c) Aggregation
- d) Composition
Answer: a) Specialization
- Which of the following best describes generalization in EER modeling?
- a) Combining multiple specific entities into a generalized entity.
- b) Dividing a generalized entity into multiple specific entities.
- c) Aggregating entities into a larger whole.
- d) Assigning attributes to entities.
Answer: a) Combining multiple specific entities into a generalized entity.
- What is the symbol used to represent aggregation in an EER diagram?
- a) Rectangle
- b) Ellipse
- c) Diamond
- d) Hollow diamond
Answer: d) Hollow diamond
- Which of the following represents a “has-a” relationship in EER modeling?
- a) Specialization
- b) Generalization
- c) Aggregation
- d) Composition
Answer: c) Aggregation
- In EER diagrams, a relationship where a whole is related to its parts is known as:
- a) Aggregation
- b) Composition
- c) Association
- d) Inheritance
Answer: a) Aggregation
- Which type of constraint specifies that an entity instance of a subclass must also be a member of its superclass in EER diagrams?
- a) Participation constraint
- b) Inheritance constraint
- c) Disjoint constraint
- d) Completeness constraint
Answer: b) Inheritance constraint
- A disjoint constraint in EER diagrams specifies that:
- a) An entity instance can be a member of only one subclass.
- b) An entity instance must be a member of all subclasses.
- c) Subclasses cannot overlap with each other.
- d) Subclasses must have unique attributes.
Answer: a) An entity instance can be a member of only one subclass.
- Which of the following constraints ensures that every entity instance of a superclass must belong to at least one subclass?
- a) Total participation
- b) Partial participation
- c) Disjoint constraint
- d) Overlap constraint
Answer: a) Total participation
- In an EER diagram, if an entity can be part of more than one subclass, this is known as:
- a) Disjointness
- b) Overlapping specialization
- c) Generalization
- d) Aggregation
Answer: b) Overlapping specialization
- Which of the following best describes completeness constraint in EER modeling?
- a) It determines whether a superclass must be associated with at least one subclass.
- b) It determines whether subclasses can overlap.
- c) It ensures all attributes are fully described.
- d) It ensures entities have a primary key.
Answer: a) It determines whether a superclass must be associated with at least one subclass.
- Which type of EER constraint specifies that each entity in the superclass can appear in only one of the subclasses?
- a) Disjoint constraint
- b) Overlapping constraint
- c) Participation constraint
- d) Completeness constraint
Answer: a) Disjoint constraint
- Which of the following is true about a partial participation constraint in EER modeling?
- a) Not all instances of the superclass must participate in the subclass relationship.
- b) All instances of the superclass must participate in the subclass relationship.
- c) Only some attributes are inherited by the subclass.
- d) Subclasses must cover all instances of the superclass.
Answer: a) Not all instances of the superclass must participate in the subclass relationship.
- In EER diagrams, what is the relationship called where a subclass inherits attributes and relationships of its superclass?
- a) Aggregation
- b) Specialization
- c) Inheritance
- d) Composition
Answer: c) Inheritance
- Which of the following is true about specialization in EER diagrams?
- a) It merges several entities into a single generalized entity.
- b) It divides a generalized entity into more specific entities.
- c) It aggregates entities into a larger whole.
- d) It establishes a “part-of” relationship.
Answer: b) It divides a generalized entity into more specific entities.
- In an EER diagram, if an entity in the superclass must be a member of at least one subclass, it is known as:
- a) Partial participation
- b) Total participation
- c) Disjointness
- d) Completeness
Answer: b) Total participation
- In an EER model, which of the following describes the concept of union type (category)?
- a) An entity that represents a collection of other entities.
- b) An attribute that is derived from other attributes.
- c) A special entity type that is a subset of the union of distinct entity types.
- d) A generalization of multiple entities into a single entity.
Answer: c) A special entity type that is a subset of the union of distinct entity types.
- Which of the following describes the difference between aggregation and composition in EER diagrams?
- a) Aggregation represents a “has-a” relationship while composition represents a “part-of” relationship with a stronger bond.
- b) Aggregation and composition are used interchangeably.
- c) Aggregation involves only attributes, while composition involves entities.
- d) Aggregation is used in ER models, while composition is used in EER models.
Answer: a) Aggregation represents a “has-a” relationship while composition represents a “part-of” relationship with a stronger bond.
More MCQs Of Database Systems
- Database Models MCQs in DBMS
- Relational Database Model MCQs in DBMS
- SQL (Structured Query Language) MCQs in DBMS
- Database Design MCQs in DBMS
- Database Management System Architecture MCQs in DBMS
- Storage and File Structure MCQs in DBMS
- Query Processing and Optimization MCQs in DBMS
- Database Transaction Management MCQs in DBMS
- Database Security and Authorization MCQs in DBMS
- Backup and Recovery MCQs in DBMS
- Distributed Databases MCQs in DBMS
- SET 1: database design mcqs (database design mcqs )
- SET 2: database mcqs with answers pdf (database mcqs with answers pdf )
- SET 3: modern database management 12th edition mcqs (modern database management 12th edition mcqs)
- SET 4: database systems mcqs (database systems mcqs)
- SET 5: dbms mcqs (dbms mcqs )
- SET 6: dbms mcqs with answers (dbms mcqs with answers)
- SET 7: solved mcqs of dbms (solved mcqs of dbms)
- SET 8: dbms mcqs with answers pdf(dbms mcqs with answers pdf)
- SET 9: relational database management system mcqs(relational database management system mcqs)
- SET 10: solved mcqs of database management system(solved mcqs of database management system)
- SET 11: basic database mcqs pdf (basic database mcqs pdf)
- SET 12: relational database management system mcqs (relational database management system mcqs )
- SET 13: database mcqs online test (database mcqs online test)
- SET 14: database interview questions mcqs (database interview questions mcqs)
- SET 15: database developer mcqs (database developer mcqs)
- SET 16: database Repeated mcqs (database Repeated mcqs)
- SET 17: Database mcqs PPSC (Database mcqs PPSC)
- SET 18: Database mcqs FPSC (Database mcqs FPSC)
- SET 19: DBMS mcqs FPSC (DBMS mcqs FPSC)
New Arrival