Database - Data and Database Administration
Exercise :: Data and Database Administration - General Questions
11. |
Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally? |
A. |
Rollback | B. |
Rollforward | C. |
Switch to duplicate database | D. |
Reprocess transactions |
Answer: Option A
Explanation:
|
12. |
Which of the following is true concerning open-source DBMS? |
A. |
Is free or nearly free database software whose source code is publicly available | B. |
Is free or nearly free database software whose source code is not publicly available | C. |
Is not competitive against PC-oriented packages and is fully SQL compliant | D. |
Is competitive against PC-oriented packages and is not fully SQL compliant |
Answer: Option A
Explanation:
|
13. |
Concurrency control is important for which of the following reasons? |
A. |
To ensure data integrity when updates occur to the database in a multiuser environment | B. |
To ensure data integrity when updates occur to the database in a single-user environment | C. |
To ensure data integrity while reading data occurs to the database in a multiuser environment | D. |
To ensure data integrity while reading data occurs to the database in a single-user environment |
Answer: Option A
Explanation:
|
14. |
Which of the following is the preferred way to recover a database after a system failure? |
A. |
Rollback | B. |
Rollforward | C. |
Switch to duplicate database | D. |
Reprocess transactions |
Answer: Option C
Explanation:
|
15. |
A data warehouse administrator is concerned with which of the following? |
A. |
The time to make a decision but not the typical roles of a database administrator | B. |
The time to make a decision and the typical roles of a database administrator | C. |
The typical roles of a data administrator and redesigning existing applications | D. |
The typical roles of a database administrator and redesigning existing applications |
Answer: Option B
Explanation:
|