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:
|
