Q. If a transaction does not modify the database until it has committed, it is said to use the ___________ technique.

View solution

Q. If database modifications occur while the transaction is still active, the transaction is said to use the ___________technique.

View solution

Q. ____________ using a log record sets the data item specified in the log record to the old value.

View solution

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