Three-Level Database Architecture Quiz

What does the external level in the Three-Level Database Architecture represent?

• How data is physically stored

• What users see and interact with

• The overall database design

• How data is indexed

Which of the following best describes the conceptual level in the Three-Level Database Architecture?

• The physical storage of data

• The overall design of the database, showing data and relationships

• The customized view of the database for different users

• The hardware components storing data

What is the purpose of the internal level in the Three-Level Database Architecture?

• To provide customized user views

• To define the relationships between data

• To handle the physical storage and indexing of data

• To allow users to interact with the database

What is the primary function of external/conceptual mapping in database architecture?

• To connect the database design to its physical storage

• To ensure user views match the main database structure

• To define the relationships between data entities

• To modify the physical storage method

What does logical data independence refer to in a database?

• The ability to change the storage medium without affecting the database structure

• The ability to modify the database structure without affecting user views or applications

• The ability to add new users to the system

• The ability to update user interfaces without affecting the database

What is physical data independence in a database system?

• The ability to change data types without affecting user queries

• The ability to change how data is physically stored without affecting the database structure

• The ability to add new tables without affecting the user interface

• The ability to change query languages without affecting the database

Which language is used to define the database structure, such as creating tables and setting constraints?

• DML

• SQL

• DDL

• Data Retrieval Language

What is the purpose of Data Manipulation Language (DML)?

• To define the structure of the database

• To manipulate data within the database (e.g., insert, update, delete)

• To query data from the database

• To perform backups and recovery

What type of device is included in the 'hardware' component of a DBMS environment?

• DBMS software

• Data

• Servers and physical computers

• End-users

In the DBMS environment, what does 'software' include?

• Data stored in the database

• Physical devices managing data

• The DBMS, operating system, and application programs

• Rules for using the database