Timedora
Free Practice Quiz Question List

Data Modeling Levels Online Quiz Questions

Use this free practice quiz with 20 questions to review Data Modeling Levels, test your knowledge, and prepare for your next test or exam.

20 questions
01
Choose one
1 point

A team specifies entities, their attributes, identifiers, and rules, while avoiding commitment to a particular database product. Which level of data modeling is this?

  1. A

    Conceptual

  2. B

    Logical

  3. C

    Physical

  4. D

    Operational

02
Choose all
1 point

Select all statements that correctly describe the conceptual, logical, or physical levels of data modeling.

  1. A

    A conceptual model names important business concepts and their relationships.

  2. B

    A logical model must specify the tables and indexes of a chosen database.

  3. C

    A logical model can specify entities, attributes, identifiers, and rules without choosing a database product.

  4. D

    A physical model describes how a chosen database implements the design.

03
True or false
1 point

A data model is an abstraction that captures facts relevant to a task rather than every detail of the real-world domain.

  1. A

    True

  2. B

    False

04
Written response
1 point

Which model level names important business concepts and their relationships? Enter the level name as one word.

05
Fill in the blank
1 point

The level describes how a chosen database implements a data model.

06
Open ended
1 point

Explain what a data model represents and distinguish its conceptual, logical, and physical levels.

07
Choose one
1 point

A design describes tables, columns, keys, indexes, and storage details for a selected database. Which model level is being described?

  1. A

    Conceptual

  2. B

    Logical

  3. C

    Physical

  4. D

    Abstract

08
Choose all
1 point

Select all statements that describe what a data model does.

  1. A

    It describes information a system needs to store.

  2. B

    It identifies properties and connections among the things represented.

  3. C

    It must capture every detail of the real-world domain.

  4. D

    It includes rules that help keep data meaningful.

09
True or false
1 point

A logical model describes the tables and indexes that a particular chosen database will use.

  1. A

    True

  2. B

    False

10
Written response
1 point

Which model level specifies entities, attributes, identifiers, and rules without committing to a particular database product? Enter the level name as one word.

11
Fill in the blank
1 point

A data model describes the information a system needs to store, including its and .

12
Choose one
1 point

A design describes the business concepts Customer and Order and states that a customer places an order. Which model level does this best represent?

  1. A

    A physical model listing database tables, columns, and indexes

  2. B

    A conceptual model naming Customer and Order and showing that a customer places an order

  3. C

    A logical model specifying identifiers and rules without choosing a database product

  4. D

    A storage plan specifying the database hardware

13
True or false
1 point

A data model is an abstraction of a real-world domain, so it records facts relevant to a task rather than every detail of reality.

  1. A

    True

  2. B

    False

14
Written response
1 point

Which model level names important business concepts and their relationships? Enter the model level as one word.

15
Choose one
1 point

Which description best fits a logical data model?

  1. A

    It names business concepts and relationships only.

  2. B

    It describes tables, columns, keys, indexes, and storage in a chosen database.

  3. C

    It specifies entities, attributes, identifiers, and rules without committing to a database product.

  4. D

    It records every detail of the real-world domain.

16
Written response
1 point

Which model level specifies entities, attributes, identifiers, and rules without committing to a particular database product? Enter the model level as one word.

17
Choose one
1 point

What does a data model describe?

  1. A

    The information a system needs to store and how that information is related

  2. B

    Only the physical storage devices used by a system

  3. C

    Every detail of the real world, whether relevant to the task or not

  4. D

    Only the names of the database products a system could use

18
Choose one
1 point

A design lists entities, attributes, identifiers, and rules but does not commit to a particular database product. Which model level is being described?

  1. A

    A specific database’s tables, columns, keys, indexes, and storage details

  2. B

    Entities, attributes, identifiers, and rules described without choosing a database product

  3. C

    Business concepts and their relationships, without specifying entities or attributes

  4. D

    Every detail of the real-world domain, including facts irrelevant to the task

19
Choose one
1 point

Which statement best describes what a data model represents?

  1. A

    The relevant information a system stores, its properties and relationships, and rules for keeping it meaningful

  2. B

    Every detail of the real-world domain, whether relevant to the task or not

  3. C

    Only the tables and storage details used by one particular database

  4. D

    Only the business concepts and their relationships, without any rules or properties

20
Choose one
1 point

A design specifies entities, their attributes, identifiers, and rules, but does not select a database product. Which level of data model is this?

  1. A

    A model that names important business concepts and their relationships

  2. B

    A model that specifies entities, attributes, identifiers, and rules without committing to a database product

  3. C

    A model that details how a chosen database implements tables, keys, indexes, and storage

  4. D

    A model that records every detail of reality, regardless of the task