Questions and answers for exam Preparation

MCQs

Total Questions : 30 | Page 2 of 3 pages

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

Reprocess transactions
Rollforward
Switch to duplicate database
Rollback

Discuss Question

Answer: Option C. -> Switch to duplicate database

Question 12. Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally?

Reprocess transactions
Switch to duplicate database
Rollforward
Rollback

Discuss Question

Answer: Option D. -> Rollback

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

Is free or nearly free database software whose source code is publicly available
Is competitive against PC-oriented packages and is not fully SQL compliant
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

Discuss Question

Answer: Option A. -> Is free or nearly free database software whose source code is publicly available

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

The time to make a decision but not the typical roles of a database administrator
The typical roles of a data administrator and redesigning existing applications
The time to make a decision and the typical roles of a database administrator
The typical roles of a database administrator and redesigning existing applications

Discuss Question

Answer: Option C. -> The time to make a decision and the typical roles of a database administrator

Question 15. Concurrency control is important for which of the following reasons?

To ensure data integrity when updates occur to the database in a single-user environment
To ensure data integrity while reading data occurs to the database in a single-user environment
To ensure data integrity when updates occur to the database in a multiuser environment
To ensure data integrity while reading data occurs to the database in a multiuser environment

Discuss Question

Answer: Option C. -> To ensure data integrity when updates occur to the database in a multiuser environment

Question 16. A transaction log shows before and after images of records that have been modified by transactions.

False
True

Discuss Question

Answer: Option A. -> False

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

False
True

Discuss Question

Answer: Option B. -> True

Question 18. To build a data warehouse and develop business intelligence applications, it is important that an organization build and maintain a comprehensive repository.