Database - Data and Database Administration
Exercise :: Data and Database Administration - General Questions
6. |
The transaction log includes which of the following? |
A. |
The before-image of a record | B. |
The after-image of a record | C. |
The before and after-image of a record | D. |
The essential data of the record |
Answer: Option D
Explanation:
|
7. |
Which of the following could cause data to be unavailable? |
A. |
Data becoming lost or inaccurate | B. |
The database server | C. |
Planned database maintenance activities | D. |
All of the above. |
Answer: Option D
Explanation:
|
8. |
A shared lock allows which of the following types of transactions to occur? |
Answer: Option C
Explanation:
|
9. |
Locking may cause which of the following problems? |
A. |
Erroneous updates | B. |
Deadlock | C. |
Versioning | D. |
All of the above. |
Answer: Option B
Explanation:
|
10. |
Performance analysis and tuning is which of the following? |
A. |
Undertaken one time at the time of a DBMS installation | B. |
Undertaken one time at the time of the implementation of a new application | C. |
Undertaken as an ongoing part of the backup of a database | D. |
Undertaken as an ongoing part of managing a database |
Answer: Option D
Explanation:
|