DBMS_7th_ch01

What is the purpose of a database system?

• To fly to the moon

• To bake cookies

• To play video games

• To manage a large, complex collection of data

What are some examples of database applications?

• Painting, Singing, Dancing

• Skiing, Swimming, Hiking

• Farming, Fishing, Cooking

• Sales, Accounting, Human Resources

What is the purpose of a Data Definition Language (DDL) in a database system?

• To define the database schema

• To define the physical layout of the database

• To define the data manipulation language

• To define the database users

What is the role of a Database Administrator (DBA)?

• Central control over the system

• Writing application programs

• Designing the physical layout of the database

• Managing the database schema

What is the purpose of the Query Processor component in a database system?

• Translates DML statements into an evaluation plan

• Stores metadata about the database structure

• Interacts with the OS file manager

• Manages transactions in the database

What is the main purpose of the Storage Manager in a database system?

• Interprets DDL statements

• Optimizes query evaluation

• Provides interface between data and application programs

• Manages transactions

What is the purpose of the Logical Design phase in database design?

• Executing low-level instructions

• Deciding on the physical layout of the database

• Deciding on the database schema

• Translating DML statements

What is the purpose of the Physical Design phase in database design?

• Deciding on the physical layout of the database

• Deciding on the database schema

• Interpreting DDL statements

• Translating DML statements

What is the purpose of the Transaction Management component in a database system?

• Ensures database consistency despite failures

• Interprets DDL statements

• Optimizes query evaluation

• Provides interface between data and application programs

What is the purpose of the Data Manipulation Language (DML) in a database system?

• Managing transactions in the database

• Interpreting DDL statements

• Storing metadata about the database structure

• Accessing and updating data organized by the data model