Q. In the __________ phase, the system replays updates of all transactions by scanning the log forward from the last checkpoint.

View solution

Q. The actions which are played in the order while recording it is called ______________ history.

View solution

Q. 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

View solution

Q. Which of the following is not a recovery technique?

View solution

Q. Checkpoints are a part of

View solution

Q. ....... deals with soft errors, such as power failures.

View solution

Q. Rollback of transactions is normally used to :

View solution

Q. A transaction performs on the isolation level of the Read Uncommitted if :

View solution

Q. Which commands are used to control which users have which privilege over which objects ?

View solution

Q. When a deadlock is detected the recovery is normally accomplished by :

View solution

Q. Which is not a desirable property of a transaction ?

View solution

Q. A directed graph which represents the deadlock is called :

View solution

Q. Transaction Throughput is :

View solution

Q. Data encryption techniques are particularly useful for

View solution

Q. Before any changes to database structure are attempted one should first:

View solution

Q. Which of the following modifications may not succeed?

View solution

Q. Because of the importance of making data model changes correctly, many professionals are ________ about using an automated process for database redesign.

View solution

Q. Which of the following can cause a transaction failure

View solution

Q. If the transaction can no longer continue with its normal execution because of some internal condition, it is called as a _________

View solution

Q. If a system has entered and undesirable state due to which it is unable to continue with normal execution, it is called as _________

View solution