DBAS6211_LU1_Exercise_1

What does the physical level of data abstraction in a database management system (DBMS) primarily deal with?

• Logical representation of data

• Conceptual organization of data

• Physical storage structure of data

• Security measures for data access

Which level of data abstraction provides a view of the database that hides details of the physical storage structures and focuses on how data is logically organized?

• Physical Database Model

• External View Model

• Conceptual Data Model

• Logical Database Model

Which of these is not a component of a DBMS?

• Statements

• Hardware

• People

• Data

Which level of data abstraction describes the overall logical structure of the entire database?

• Application level

• Physical level

• Conceptual level

• External level

At which level of data abstraction do users interact with the database by writing queries and generating reports?

• External level

• Conceptual level

• Logical level

• Physical level

Which level of data abstraction focuses on the relationships between data entities and the constraints on data operations?

• Conceptual level

• Logical level

• External level

• Application level

Which level of data abstraction deals with the way data is stored in terms of bytes, blocks, and pages?

• Logical level

• External level

• Conceptual level

• Physical level

Which level of data abstraction focuses on representing data in a way that is closest to the user's perception?

• Physical level

• External level

• Conceptual level

• Logical level