Extended ER modeling MCQs in DBMS

By: Prof. Dr. Fazal Rehman | Last updated: September 23, 2024

MCQs on Extended Entity-Relationship (EER) Modeling in DBMS

1. 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
2. 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
3. Which of the following concepts is not part of the EER model?
   • a) Specialization
   • b) Generalization
   • c) Aggregation
   • d) Normalization
   Answer: d) Normalization
4. 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
5. 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.
6. 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
7. Which of the following represents a “has-a” relationship in EER modeling?
   • a) Specialization
   • b) Generalization
   • c) Aggregation
   • d) Composition
   Answer: c) Aggregation
8. 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
9. 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
10. 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.
11. 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
12. 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
13. 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.
14. 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
15. 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.
16. 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
17. 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.
18. 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
19. 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.
20. 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

1. Database Models MCQs in DBMS
   1. Hierarchical model MCQs in DBMS
   2. Network model MCQs in DBMS
   3. Relational model MCQs in DBMS
   4. Object-oriented model MCQs in DBMS
   5. NoSQL databases MCQs in DBMS
2. Relational Database Model MCQs in DBMS
   1. tables, attributes, tuples, and relations MCQs in DBMS
   2. Primary keys and foreign keys MCQs in DBMS
   3. Integrity constraints MCQs in DBMS
3. SQL (Structured Query Language) MCQs in DBMS
   1. Data Definition Language (DDL) MCQs in DBMS
   2. Data Manipulation Language (DML) MCQs in DBMS
   3. Data Control Language (DCL) MCQs in DBMS
   4. Transaction Control Language (TCL) MCQs in DBMS
   5. Advanced SQL queries and functions MCQs in DBMS
4. Database Design MCQs in DBMS
   1. Entity-Relationship (ER) modeling MCQs in DBMS
   2. Extended ER modeling MCQs in DBMS
   3. Normalization and normal forms (1NF, 2NF, 3NF, BCNF) MCQs in DBMS
   4. Denormalization MCQs in DBMS
5. Database Management System Architecture MCQs in DBMS
   1. Three-schema architecture (external, conceptual, internal) MCQs in DBMS
   2. Data independence MCQs in DBMS
   3. DBMS components and functions MCQs in DBMS
6. Storage and File Structure MCQs in DBMS
   1. Data storage on physical media MCQs in DBMS
   2. File organization and access methods MCQs
   3. Indexing (B-trees, hash indexing) MCQs in DBMS
   4. RAID technology MCQs in DBMS
7. Query Processing and Optimization MCQs in DBMS
8. Database Transaction Management MCQs in DBMS
   1. ACID properties (Atomicity, Consistency, Isolation, Durability) MCQs in DBMS
   2. Transaction states and lifecycle MCQs in DBMS
   3. Concurrency control techniques (locking, timestamping, multiversion) MCQs in DBMS
   4. Deadlock detection and resolution MCQs in DBMS
9. Database Security and Authorization MCQs in DBMS
   1. Authentication and authorization mechanisms MCQs in DBMS
   2. Data encryption techniques MCQs in DBMS
   3. Role-based access control MCQs in DBMS
   4. SQL injection prevention MCQs in DBMS
10. Backup and Recovery MCQs in DBMS
    1. Backup types and strategies MCQs in DBMS
    2. Recovery techniques (log-based, shadow paging) MCQs in DBMS
    3. Disaster recovery planning MCQs in DBMS
11. Distributed Databases MCQs in DBMS
    1. Distributed database architecture MCQs MCQs in DBMS
    2. Data fragmentation, replication, and allocation in DBMS
    3. Distributed query processing MCQs in DBMS
    4. Consistency models and protocols MCQs in DBMS

1. SET 1: database design mcqs (database design mcqs )
2. SET 2: database mcqs with answers pdf (database mcqs with answers pdf )
3. SET 3: modern database management 12th edition mcqs (modern database management 12th edition mcqs)
4. SET 4: database systems mcqs (database systems mcqs)
5. SET 5: dbms mcqs (dbms mcqs )
6. SET 6: dbms mcqs with answers (dbms mcqs with answers)
7. SET 7: solved mcqs of dbms (solved mcqs of dbms)
8. SET 8: dbms mcqs with answers pdf(dbms mcqs with answers pdf)
9. SET 9: relational database management system mcqs(relational database management system mcqs)
10. SET 10: solved mcqs of database management system(solved mcqs of database management system)
11. SET 11: basic database mcqs pdf (basic database mcqs pdf)
12. SET 12: relational database management system mcqs (relational database management system mcqs )
13. SET 13: database mcqs online test (database mcqs online test)
14. SET 14: database interview questions mcqs (database interview questions mcqs)
15. SET 15: database developer mcqs (database developer mcqs)
16. SET 16: database Repeated mcqs (database Repeated mcqs)
17. SET 17: Database mcqs PPSC (Database mcqs PPSC)
18. SET 18: Database mcqs FPSC (Database mcqs FPSC)
19. SET 19: DBMS mcqs FPSC (DBMS mcqs FPSC)