ACorrect Answer

Assess logging is when a record is kept of all attribute accesses made by a particular user. It is not directly relevent with supporting data recovery.

close

BIncorrect Answer

A dump is when the whole database is stopped in a consistent state and then copied onto another storage medium (such as tape). If something later happens to the database, it can be reloaded from the second storage medium.

close

CIncorrect Answer

This is the process by which locks are obtained by a transaction (locks are obtained or promoted when needed, but only released at the end of a transaction). Such an approach is desirable to maintain consistency in a database system.

close

DIncorrect Answer

A checkpoint is when the database reaches a consistent state, and all transactions have either been committed or aborted. It is during this time that logs or journals can be truncated.

close

EIncorrect Answer

This is the record of attribute changes made by transactions since the last checkpoint. It is useful when performing roll-backs or roll-forwards.

close

A B C D E TELL ME NEXT INDEX
 
 
Which of the following is not used to support recovery and consistency in a database system?
  1. Access logging
  2. A dump
  3. Two phase commit
  4. Checkpointing
  5. A journal