MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 657 Mcqs, each offering curated multiple-choice questions to sharpen your Testing Subject knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
When a deadlock is detected the recovery is normally accomplished by : |
| A. | rollback of transaction |
| B. | locking of data |
| C. | consistency checking |
| D. | none of these |
| Answer» B. locking of data | |
| 2. |
Which of the following is used for undo operations alone ? |
| A. | Logical logging |
| B. | Physical logging |
| C. | Physical log records |
| D. | Physical logging and Physical log records |
| Answer» B. Physical logging | |
| 3. |
Checkpoints are a part of |
| A. | Recovery measures |
| B. | Security measures |
| C. | Concurrency measures |
| D. | Authorization measures |
| Answer» B. Security measures | |
| 4. |
The assumption that the hardware errors bring the system to a halt is called as ________ |
| A. | Halter assumption |
| B. | Phantom assumption |
| C. | Fail-stop assumption |
| D. | Disk failure |
| Answer» D. Disk failure | |
| 5. |
If the database modifications occur while the transaction is still active, the transaction is said to use the __________ modification technique |
| A. | Deferred |
| B. | Immediate |
| C. | More than one of the mentioned |
| D. | None of the mentioned |
| Answer» C. More than one of the mentioned | |
| 6. |
The log is a sequence of ___________, recording all the update activities in the database. |
| A. | Log records |
| B. | Records |
| C. | Entries |
| D. | Redo |
| Answer» B. Records | |
| 7. |
A special redo-only log record is written to the log, where V1 is the value being restored to data item Xj during the rollback. These log records are sometimes called |
| A. | Log records |
| B. | Records |
| C. | Compensation log records |
| D. | Compensation redo records |
| Answer» D. Compensation redo records | |
| 8. |
In the __________ phase, the system replays updates of all transactions by scanning the log forward from the last checkpoint. |
| A. | Repeating |
| B. | Redo |
| C. | Replay |
| D. | Undo |
| Answer» C. Replay | |
| 9. |
The actions which are played in the order while recording it is called ______________ history. |
| A. | Repeating |
| B. | Redo |
| C. | Replay |
| D. | Undo |
| Answer» B. Redo | |
| 10. |
The current copy of the database is identified by a pointer, called _____________, which is stored on disk. |
| A. | Db-pointer |
| B. | Update log |
| C. | Update log records |
| D. | All of the mentioned |
| Answer» B. Update log | |