DATA AND DATABASE ADMINISTRATION QUIZ

A data warehouse administrator is concerned with which of the following?

The time to make a decision and the typical roles of a database administrator

The typical roles of a data administrator and redesigning existing applications

The typical roles of a database administrator and redesigning existing applications

The time to make a decision but not the typical roles of a database administrator

TRUE ANSWER : ?
YOUR ANSWER : ?

Performance analysis and tuning is which of the following?

Undertaken as an ongoing part of the backup of a database

Undertaken as an ongoing part of managing a database

Undertaken one time at the time of a DBMS installation

Undertaken one time at the time of the implementation of a new application

TRUE ANSWER : ?
YOUR ANSWER : ?

Incorrect data is easy to detect.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is the preferred way to recover a database after a system failure?

Switch to duplicate database

Rollforward

Rollback

Reprocess transactions

TRUE ANSWER : ?
YOUR ANSWER : ?

The transaction log includes which of the following?

The before and after-image of a record

The before-image of a record

The after-image of a record

The essential data of the record

TRUE ANSWER : ?
YOUR ANSWER : ?

Queries that do full table scans should be avoided.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Authorization tables contain highly sensitive data and should be protected by stringent security rules.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Failure to control confidentiality may lead to loss of competitiveness.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A shared lock allows which of the following types of transactions to occur?

Delete

Read

Insert

Update

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following could cause data to be unavailable?

All of these

Planned database maintenance activities

The database server

Data becoming lost or inaccurate

TRUE ANSWER : ?
YOUR ANSWER : ?

↑