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