adplus-dvertising
frame-decoration

Question

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

a.

Deferred-modification

b.

Late-modification

c.

Immediate-modification

d.

Undo

Posted under Recovery System DBMS

Answer: (c).Immediate-modification

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

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

Similar Questions

Discover Related MCQs

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

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

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

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

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

Q. Checkpoints are a part of

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

Q. Rollback of transactions is normally used to :

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

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

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

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

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

Q. Transaction Throughput is :

Q. Data encryption techniques are particularly useful for

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

Q. Which of the following modifications may not succeed?

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

Q. Which of the following can cause a transaction failure

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