Data Modeling MCQ Questions & Answer PDF Download

Data Modeling Exam Questions and Answers | DBMS Data Modeling MCQ Questions | Data Models Multiple Choice Questions and Answer

Data Modeling Quiz: Data modeling is the process of diagramming data flows. When creating a new /alternate database structure, the designer starts with a diagram of how data will flow into and out of the database. Here we have upload 30 Data Modelling MCQ Questions and Answer. Aspirants working as a Data Modeler with requires a bachelor’s degree in computer science, information technology/related field. Candidates must have set of skills in Data Modeling. Person who are searching for Data Modeling with ER Model Questions and answers kindly refer this page. We have additionally given Data Models MCQ Questions & Answer PDF.

Data Model Types

  • Conceptual data models,
  • Logical data models,
  • Physical data models

Important Links

Click Here for Psychology MCQ Question and Answer 
Click here for Ancient Indian History MCQ Quiz

Data Modelling With ER Model Questions and Answer

1.  A recursive relationship is a relationship between an entity and ________ 

  1. a subtype entity
  2. itself
  3. an instance entity
  4. an archetype entity

Answer: itself

2. Which of the following refers to something that can be identified in the user’s work environment, something that the users want to track?

  1. Attribute
  2. Identifier
  3. Entity
  4. Relationship

Answer: Entity

3. Which of the following indicates the minimum number of entities that must be involved in a relationship?

  1. Maximum cardinality
  2. Minimum cardinality
  3. Greater Entity Count
  4. ERD

Answer: Minimum cardinality

4. Which type of entity cannot exist in the database unless another type of entity also exists in the database, but does not require that the identifier of that other entity be included as part of its own identifier?

  1. Strong entity
  2. ID- independent entity
  3. Weak entity
  4. ID-dependent entity

Answer: Weak entity

5. In which of the following is a single-entity instance of one type related to many entity instances of another type?

  1. One-to-Many Relationship
  2. One-to-One Relationship
  3. Composite Relationship
  4. Many-to-Many Relationship

Answer: One-to-Many Relationship

6. Properties that describe the characteristics of entities are called________

  1. attributes
  2. identifiers
  3. entities
  4. relationships

Answer: attributes

7. Which of the following indicates the maximum number of entities that can be involved in a relationship?

  1. Maximum cardinality
  2. ERD
  3. Minimum cardinality
  4. Greater Entity Count

Answer: Maximum cardinality

8. In which of the following can many entity instances of one type be related to many entity instances of another type?

  1. One-to-Many Relationship
  2. Many-to-Many Relationship
  3. One-to-One Relationship

Answer: Many-to-Many Relationship

9. An attribute that names or identifies entity instances is a(n)____________

  1. attribute
  2. entity
  3. relationship
  4. identifier

Answer: identifier

10. In a one-to-many relationship, the entity that is on the one side of the relationship is called a(n) ________ entity.

  1. child
  2. parent
  3. instance
  4. subtype

Answer: parent

11. Which of the following refers to an entity in which the identifier of one entity includes the identifier of another entity?

  1. Strong entity
  2. ID-dependent entity
  3. Weak entity
  4. ID-independent entity

Answer: ID-dependent entity

12. Which type of entity represents an actual occurrence of an associated generalized entity?

  1. Subtype entity
  2. Supertype entity
  3. Archetype entity
  4. Instance entity

Answer: Instance entity

13. Which type of entity is related to two or more associated entities that each contain specialized attributes that apply to some but not all of the instances of the entity?

  1. Archetype entity
  2. Subtype entity
  3. Supertype entity
  4. Instance entity

Answer: Supertype entity

14. Composite identifiers consist of two or more attributes.

  1. True
  2. False

Answer: True

15. A subtype entity is a special case of another entity called a supertype entity.

  1. False
  2. True

Answer: True

16. When designing a database, first identify the entities, then determine the attributes, and finally establish the relationships.

  1. False
  2. True

Answer: False

17. A minimum cardinality is the minimum number of entity instances that may participate in a relationship instance.

  1. False
  2. True

Answer: False

18. Entities use identifiers while tables use keys.

  1. False
  2. True

Answer: True

19. An ID-dependent entity is an entity whose identifier is a composite identifier where no portion of the composite identifier is an identifier of another entity.

  1. True
  2. False

Answer: False

20. In a one-to-many relationship, the entity that is on the many side of the relationship is called a(n) ________ entity.

  1. child
  2. instance
  3. parent
  4. subtype

Answer: child

21. Which type of entity has its relationship to another entity determined by an attribute in that other entity called a discriminator?

  1. Subtype entity
  2. Instance entity
  3. Archetype entity
  4. Supertype entity

Answer: Subtype entity

22. A ternary relationship is so called because in contains two entities and one association between them.

  1. False
  2. True

Answer: False

23. Which type of entity represents a logical generalization whose actual occurrence is represented by a second, associated entity?

  1. Subtype entity
  2. Supertype entity
  3. Archetype entity
  4. Instance entity

Answer: Archetype entity

24. Entities can be associated with one another in which of the following?

  1. Attributes
  2. Identifiers
  3. Entities
  4. Relationships

Answer: Relationships

25. An attribute describes the entity’s characteristics.

  1. False
  2. True

Answer: True

26. All instances of an entity class have the same attributes.

  1. False
  2. True

Answer: True

27. In which of the following is a single-entity instance of one type of related to a single-entity instance of another type?

  1. One-to-Many Relationship
  2. One-to-One Relationship
  3. Composite Relationship
  4. Many-to-Many Relationship

Answer: One-to-One Relationship

28. Which of the following is NOT a basic element of all versions of the E-R model?

  1. Attributes
  2. Primary keys
  3. Entities
  4. Relationships

Answer: Primary keys

29. The degree of a relationship refers to the number of entity classes in the relationship

  1. False
  2. True

Answer: True

30. Entities of a given type are grouped into a(n)____________

  1. entity class
  2. database
  3. ERD
  4. attribute

Answer: entity class

Visit dailyrecruitment.in to get more information like GK Quiz, admit card, syllabus, latest updates and upcoming notification.

Download Data Modelling MCQ Questions and Answer PDF