DBMS · ER Model interview questions

39 real DBMS · ER Model questions from the Computer Science Fundamentals bank, as asked in Indian campus drives and tech interviews. Every question has a verified answer and an AI-tutor explanation on placd — free to start.

1. What is Entity?

Junior
  1. A.a top-down abstraction splitting an entity into more specific sub-entities
  2. B.a bottom-up abstraction combining similar entities into a higher-level parent entity
  3. C.a constraint where only some entity instances need to take part in a relationship
  4. D.a distinguishable real-world object represented as a rectangle in an ER diagram
Reveal the answer + AI explanation — free account

3. Which statement is correct?

Junior
  1. A.Entity — a top-down abstraction splitting an entity into more specific sub-entities
  2. B.Entity — an attribute whose value is computed from other attributes rather than stored
  3. C.Entity — a distinguishable real-world object represented as a rectangle in an ER diagram
  4. D.Entity — an entity that cannot be uniquely identified by its own attributes and depends on an owner entity
Reveal the answer + AI explanation — free account

4. What is Weak entity?

Mid
  1. A.an entity that cannot be uniquely identified by its own attributes and depends on an owner entity
  2. B.an association among entities shown as a diamond in an ER diagram
  3. C.a constraint where only some entity instances need to take part in a relationship
  4. D.a top-down abstraction splitting an entity into more specific sub-entities
Reveal the answer + AI explanation — free account

6. Which statement is correct?

Mid
  1. A.Weak entity — an attribute that can hold more than one value for a single entity instance
  2. B.Weak entity — a mapping where one entity instance relates to many instances of another
  3. C.Weak entity — a constraint requiring every entity instance to take part in a relationship
  4. D.Weak entity — an entity that cannot be uniquely identified by its own attributes and depends on an owner entity
Reveal the answer + AI explanation — free account

7. What is Relationship?

Junior
  1. A.a mapping where instances on both sides can relate to multiple instances of the other
  2. B.a constraint where only some entity instances need to take part in a relationship
  3. C.an association among entities shown as a diamond in an ER diagram
  4. D.an attribute whose value is computed from other attributes rather than stored
Reveal the answer + AI explanation — free account

9. Which statement is correct?

Junior
  1. A.Relationship — an attribute that can hold more than one value for a single entity instance
  2. B.Relationship — a top-down abstraction splitting an entity into more specific sub-entities
  3. C.Relationship — an association among entities shown as a diamond in an ER diagram
  4. D.Relationship — an abstraction treating a relationship and its entities as a single higher-level entity
Reveal the answer + AI explanation — free account

10. What is Composite attribute?

Mid
  1. A.an attribute whose value is computed from other attributes rather than stored
  2. B.a top-down abstraction splitting an entity into more specific sub-entities
  3. C.an attribute that can be subdivided into smaller meaningful sub-attributes
  4. D.a mapping where one entity instance relates to many instances of another
Reveal the answer + AI explanation — free account

12. Which statement is correct?

Mid
  1. A.Composite attribute — a constraint requiring every entity instance to take part in a relationship
  2. B.Composite attribute — a top-down abstraction splitting an entity into more specific sub-entities
  3. C.Composite attribute — an abstraction treating a relationship and its entities as a single higher-level entity
  4. D.Composite attribute — an attribute that can be subdivided into smaller meaningful sub-attributes
Reveal the answer + AI explanation — free account

13. What is Multivalued attribute?

Mid
  1. A.an attribute that can hold more than one value for a single entity instance
  2. B.an association among entities shown as a diamond in an ER diagram
  3. C.a distinguishable real-world object represented as a rectangle in an ER diagram
  4. D.an attribute whose value is computed from other attributes rather than stored
Reveal the answer + AI explanation — free account

15. Which statement is correct?

Mid
  1. A.Multivalued attribute — a mapping where instances on both sides can relate to multiple instances of the other
  2. B.Multivalued attribute — an attribute that can hold more than one value for a single entity instance
  3. C.Multivalued attribute — an attribute whose value is computed from other attributes rather than stored
  4. D.Multivalued attribute — an abstraction treating a relationship and its entities as a single higher-level entity
Reveal the answer + AI explanation — free account

16. What is Derived attribute?

Mid
  1. A.a top-down abstraction splitting an entity into more specific sub-entities
  2. B.an attribute whose value is computed from other attributes rather than stored
  3. C.an attribute that can be subdivided into smaller meaningful sub-attributes
  4. D.a constraint where only some entity instances need to take part in a relationship
Reveal the answer + AI explanation — free account

18. Which statement is correct?

Mid
  1. A.Derived attribute — a distinguishable real-world object represented as a rectangle in an ER diagram
  2. B.Derived attribute — an attribute whose value is computed from other attributes rather than stored
  3. C.Derived attribute — a constraint requiring every entity instance to take part in a relationship
  4. D.Derived attribute — an attribute that can hold more than one value for a single entity instance
Reveal the answer + AI explanation — free account

19. What is One-to-many relationship?

Junior
  1. A.an attribute that can hold more than one value for a single entity instance
  2. B.a mapping where one entity instance relates to many instances of another
  3. C.an association among entities shown as a diamond in an ER diagram
  4. D.an entity that cannot be uniquely identified by its own attributes and depends on an owner entity
Reveal the answer + AI explanation — free account

21. Which statement is correct?

Junior
  1. A.One-to-many relationship — an entity that cannot be uniquely identified by its own attributes and depends on an owner entity
  2. B.One-to-many relationship — an attribute whose value is computed from other attributes rather than stored
  3. C.One-to-many relationship — a mapping where one entity instance relates to many instances of another
  4. D.One-to-many relationship — a distinguishable real-world object represented as a rectangle in an ER diagram
Reveal the answer + AI explanation — free account

22. What is Many-to-many relationship?

Mid
  1. A.a constraint requiring every entity instance to take part in a relationship
  2. B.a mapping where instances on both sides can relate to multiple instances of the other
  3. C.a constraint where only some entity instances need to take part in a relationship
  4. D.an entity that cannot be uniquely identified by its own attributes and depends on an owner entity
Reveal the answer + AI explanation — free account

24. Which statement is correct?

Mid
  1. A.Many-to-many relationship — a top-down abstraction splitting an entity into more specific sub-entities
  2. B.Many-to-many relationship — a bottom-up abstraction combining similar entities into a higher-level parent entity
  3. C.Many-to-many relationship — an abstraction treating a relationship and its entities as a single higher-level entity
  4. D.Many-to-many relationship — a mapping where instances on both sides can relate to multiple instances of the other
Reveal the answer + AI explanation — free account

25. What is Generalization?

Mid
  1. A.a bottom-up abstraction combining similar entities into a higher-level parent entity
  2. B.an association among entities shown as a diamond in an ER diagram
  3. C.a top-down abstraction splitting an entity into more specific sub-entities
  4. D.a constraint requiring every entity instance to take part in a relationship
Reveal the answer + AI explanation — free account

27. Which statement is correct?

Mid
  1. A.Generalization — a constraint requiring every entity instance to take part in a relationship
  2. B.Generalization — an attribute that can hold more than one value for a single entity instance
  3. C.Generalization — a distinguishable real-world object represented as a rectangle in an ER diagram
  4. D.Generalization — a bottom-up abstraction combining similar entities into a higher-level parent entity
Reveal the answer + AI explanation — free account

28. What is Specialization?

Mid
  1. A.a top-down abstraction splitting an entity into more specific sub-entities
  2. B.an abstraction treating a relationship and its entities as a single higher-level entity
  3. C.a mapping where one entity instance relates to many instances of another
  4. D.a mapping where instances on both sides can relate to multiple instances of the other
Reveal the answer + AI explanation — free account

30. Which statement is correct?

Mid
  1. A.Specialization — an attribute that can hold more than one value for a single entity instance
  2. B.Specialization — a mapping where instances on both sides can relate to multiple instances of the other
  3. C.Specialization — a top-down abstraction splitting an entity into more specific sub-entities
  4. D.Specialization — a distinguishable real-world object represented as a rectangle in an ER diagram
Reveal the answer + AI explanation — free account

Showing 30 of 39 DBMS · ER Model questions — the full set, with answers, explanations and an AI tutor on every question, is inside.

Free to start

Answers, AI explanations, and a scored voice mock interview

Sign up free to check your answers with explanations, ask the AI tutor anything on any question, and take one full AI mock interview — scored like a real panel.

Practice DBMS · ER Model free