MCQs on Entity-Relationship (ER) Modeling in DBMS
- What is the primary purpose of an Entity-Relationship (ER) diagram in DBMS?
- a) To normalize the database.
- b) To define the structure of the database.
- c) To visually represent the data and relationships in the database.
- d) To optimize database queries.
Answer: c) To visually represent the data and relationships in the database.
- In an ER diagram, an entity is represented by a:
- a) Circle
- b) Rectangle
- c) Diamond
- d) Triangle
Answer: b) Rectangle
- Which of the following symbols in an ER diagram represents a relationship?
- a) Circle
- b) Rectangle
- c) Diamond
- d) Ellipse
Answer: c) Diamond
- In an ER diagram, attributes are represented by:
- a) Rectangles
- b) Diamonds
- c) Ovals
- d) Triangles
Answer: c) Ovals
- A primary key in an ER diagram is usually underlined. Which of the following best describes a primary key?
- a) An attribute or set of attributes that uniquely identifies a record.
- b) An attribute that can be used to join two tables.
- c) A foreign key that refers to another table.
- d) An attribute that is always unique but not necessary for identification.
Answer: a) An attribute or set of attributes that uniquely identifies a record.
- Which of the following describes a weak entity in an ER diagram?
- a) An entity that does not have any attributes.
- b) An entity that cannot be uniquely identified by its attributes alone.
- c) An entity that is not related to any other entity.
- d) An entity with a composite primary key.
Answer: b) An entity that cannot be uniquely identified by its attributes alone.
- A relationship where one entity is associated with multiple instances of another entity is called a:
- a) One-to-One relationship
- b) One-to-Many relationship
- c) Many-to-Many relationship
- d) Self-Referencing relationship
Answer: b) One-to-Many relationship
- In an ER diagram, a derived attribute is usually represented by:
- a) A dashed oval
- b) A solid oval
- c) A dashed rectangle
- d) A solid diamond
Answer: a) A dashed oval
- Which of the following best describes a composite attribute?
- a) An attribute that consists of multiple values.
- b) An attribute that can be divided into smaller sub-parts.
- c) An attribute that is calculated from other attributes.
- d) An attribute that is shared by multiple entities.
Answer: b) An attribute that can be divided into smaller sub-parts.
- A self-referencing relationship is also known as:
- a) Unary relationship
- b) Binary relationship
- c) Ternary relationship
- d) Recursive relationship
Answer: d) Recursive relationship
- In an ER diagram, the total participation of an entity set in a relationship set is indicated by:
- a) Single line
- b) Double line
- c) Dashed line
- d) Bold line
Answer: b) Double line
- A multi-valued attribute in an ER diagram is represented by:
- a) A double oval
- b) A single oval
- c) A dashed oval
- d) A rectangle
Answer: a) A double oval
- Which of the following is true about a ternary relationship?
- a) It involves three entities.
- b) It involves two entities.
- c) It involves four entities.
- d) It involves an entity and its attributes.
Answer: a) It involves three entities.
- In an ER diagram, generalization is represented by:
- a) A triangle pointing towards the supertype entity.
- b) A triangle pointing towards the subtype entity.
- c) A rectangle connected to multiple diamonds.
- d) An oval connected to multiple rectangles.
Answer: a) A triangle pointing towards the supertype entity.
- Specialization in an ER diagram refers to:
- a) Creating a generalized entity from multiple specific entities.
- b) Creating specific entities from a generalized entity.
- c) Combining multiple attributes into one attribute.
- d) Dividing one attribute into multiple sub-attributes.
Answer: b) Creating specific entities from a generalized entity.
- In an ER diagram, which notation indicates a mandatory relationship?
- a) A single line
- b) A dashed line
- c) A double line
- d) A dotted line
Answer: c) A double line
- What is the purpose of an identifying relationship in an ER diagram?
- a) To establish a relationship between a weak entity and its owner entity.
- b) To establish a relationship between two strong entities.
- c) To identify the attributes of an entity.
- d) To establish a relationship between an attribute and an entity.
Answer: a) To establish a relationship between a weak entity and its owner entity.
- Which of the following is a true statement about ER modeling?
- a) ER modeling is primarily used for physical database design.
- b) ER modeling helps to identify entities, attributes, and relationships.
- c) ER modeling is a sequential database modeling technique.
- d) ER modeling is only applicable to relational databases.
Answer: b) ER modeling helps to identify entities, attributes, and relationships.
- Which of the following is a characteristic of a weak entity set?
- a) It always has a primary key.
- b) It has a partial key and depends on a strong entity.
- c) It is independent of other entities.
- d) It does not participate in any relationships.
Answer: b) It has a partial key and depends on a strong entity.
- Which of the following is true about a partial key in an ER diagram?
- a) It uniquely identifies a weak entity set.
- b) It is a foreign key in the owner entity.
- c) It is always a composite attribute.
- d) It identifies a strong entity set.
Answer: a) It uniquely identifies a weak entity set.
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