Database Administrator Quiz

What is the primary role of a database administrator?

• To interpret queries and create plans to modify the database

• To ensure transactions are properly executed

• To secure the database system against unauthorized users

• To translate query processor instructions into low-level file-system commands

Which of the following database roles is responsible for ensuring data is consistent with structural and business rules?

• Authorization

• Rules

• Query processor

• Transaction manager

What does the query processor do?

• It secures the database system against unauthorized users

• It interprets queries and creates a plan to modify the database or retrieve data

• It ensures transactions are properly executed

• It translates query processor instructions into low-level file-system commands

Which SQL statement is used to retrieve data from a table?

• INSERT

• SELECT

• UPDATE

• DELETE

What data type in SQL stores year, month, and day?

• INT

• DECIMAL

• VARCHAR

• DATE

Which role in database management prevents conflicts between concurrent transactions?

• Database administrator

• Authorization

• Query processor

• Transaction manager

What does the SQL CREATE TABLE statement do?

• It retrieves data from a table

• It modifies data in a table

• It creates a new table by specifying the table and column names

• It deletes rows from a table

Which phase specifies database requirements without regard to a specific database system?

• Logical design

• Physical design

• Analysis

• Implementation

What is an entity in the context of database design?

• A descriptive property of an attribute

• A person, place, activity, or thing

• A link between attributes

• A type of database

Which phase of database design adds indexes and specifies how tables are organized on storage media?

• Analysis

• Logical design

• Physical design

• Conceptual design