DATA WAREHOUSING QUIZ

Data modeling and database design are key responsibilities of data and data base administration.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Incorrect data is easy to detect.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Locking may cause which of the following problems?

Versioning

Deadlock

All of these

Erroneous updates

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Rollforward

Rollback

Switch to duplicate database

Reprocess transactions

TRUE ANSWER : ?
YOUR ANSWER : ?

A traditional data administrator performs which of the following roles?

Tune database performance

Establish backup and recovery procedures

Resolve data ownership issues

Protect the security of the database

TRUE ANSWER : ?
YOUR ANSWER : ?

Failure to control confidentiality may lead to loss of competitiveness.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is true concerning open-source DBMS?

Is competitive against PC-oriented packages and is not fully SQL compliant

Is free or nearly free database software whose source code is publicly available

Is not competitive against PC-oriented packages and is fully SQL compliant

Is free or nearly free database software whose source code is not publicly available

TRUE ANSWER : ?
YOUR ANSWER : ?

Queries that do full table scans should be avoided.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Update

Read

Insert

Delete

TRUE ANSWER : ?
YOUR ANSWER : ?

With concurrent processing involving updates, a database with concurrency control will be compromised due to interference between users.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?