Database - Data and Database Administration

Exercise : Data and Database Administration - General Questions
6.
The transaction log includes which of the following?
The before-image of a record
The after-image of a record
The before and after-image of a record
The essential data of the record
Answer: Option
Explanation:
No answer description is available. Let's discuss.

7.
Which of the following could cause data to be unavailable?
Data becoming lost or inaccurate
The database server
Planned database maintenance activities
All of the above.
Answer: Option
Explanation:
No answer description is available. Let's discuss.

8.
A shared lock allows which of the following types of transactions to occur?
Delete
Insert
Read
Update
Answer: Option
Explanation:
No answer description is available. Let's discuss.

9.
Locking may cause which of the following problems?
Erroneous updates
Deadlock
Versioning
All of the above.
Answer: Option
Explanation:
No answer description is available. Let's discuss.

10.
Performance analysis and tuning is which of the following?
Undertaken one time at the time of a DBMS installation
Undertaken one time at the time of the implementation of a new application
Undertaken as an ongoing part of the backup of a database
Undertaken as an ongoing part of managing a database
Answer: Option
Explanation:
No answer description is available. Let's discuss.