Q. In the ___________ scheme, a transaction that wants to update the database first creates a complete copy of the database.

View solution

Q. The ____________ scheme uses a page table containing pointers to all pages; the page table itself and all updated pages are copied to a new location.

View solution

Q. The current copy of the database is identified by a pointer, called _____________, which is stored on disk.

View solution

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