Once the lower-level lock is released, the operation cannot be undone by using the old values of updated data items, and must instead be undone by executing a compensating operation; such an operation is called(a) Logical operation(b) Redo operation(c) Logical undo operation(d) Undo operationThis question was addressed to me in an interview for internship.Question is from Lock Release and Undo Operations in division Recovery System of Database Management

Once the lower-level lock is released, the operation cannot be undone

1.	Once the lower-level lock is released, the operation cannot be undone by using the old values of updated data items, and must instead be undone by executing a compensating operation; such an operation is called(a) Logical operation(b) Redo operation(c) Logical undo operation(d) Undo operationThis question was addressed to me in an interview for internship.Question is from Lock Release and Undo Operations in division Recovery System of Database Management
Answer» The correct OPTION is (a) LOGICAL operation The BEST I can EXPLAIN: It is important that the lower-level locks acquired during an operation are SUFFICIENT to perform a subsequent logical undo of the operation.

Discussion

No Comment Found

Related InterviewSolutions

A dump of the database contents is also referred to as an _____________ dump.(a) Archival(b) Fuzzy(c) SQL(d) All of the mentionedThe question was asked in semester exam.Question is taken from Failure with Nonvolatile Storage in portion Recovery System of Database Management
In the __________ phase, the system replays updates of all transactions by scanning the log forward from the last checkpoint.(a) Repeating(b) Redo(c) Replay(d) UndoThis question was posed to me in a job interview.My question comes from Recovery in chapter Recovery System of Database Management
If a transaction does not modify the database until it has committed, it is said to use the ___________ technique.(a) Deferred-modification(b) Late-modification(c) Immediate-modification(d) UndoI had been asked this question in my homework.My doubt stems from Recovery topic in division Recovery System of Database Management
Shadow paging has(a) no redo(b) no undo(c) redo but no undo(d) neither redo nor undoI got this question during an online exam.I want to ask this question from Lock Release and Undo Operations in section Recovery System of Database Management
The system has entered an undesirable state (for example, deadlock), as a result of which a transaction cannot continue with its normal execution. This is(a) Read error(b) Boot error(c) Logical error(d) System errorI have been asked this question in examination.The above asked question is from Failure Classification in division Recovery System of Database Management
Which of the following belongs to transaction failure(a) Read error(b) Boot error(c) Logical error(d) All of the mentionedThe question was asked during an online exam.The query is from Failure Classification topic in section Recovery System of Database Management
Immediate database modification technique uses(a) Both undo and redo(b) Undo but no redo(c) Redo but no undo(d) Neither undo nor redoThe question was asked at a job interview.My query is from Lock Release and Undo Operations topic in division Recovery System of Database Management
Non-volatile storage needs to have a _________ where the loses in future can be recovered.(a) Dump(b) Recover place(c) Disk(d) Redo planThis question was posed to me by my college director while I was bunking the class.I'd like to ask this question from Failure with Nonvolatile Storage topic in section Recovery System of Database Management
The ALU of a computer normally contains a number of high speed storage element called(a) Semiconductor memory(b) Registers(c) Hard disks(d) Magnetic diskI have been asked this question in examination.I want to ask this question from Failure with Nonvolatile Storage topic in division Recovery System of Database Management
The magnetic storage chip used to provide non-volatile direct access storage of data and that have no moving parts are known as(a) Magnetic core memory(b) Magnetic tape memory(c) Magnetic disk memory(d) Magnetic bubble memoryThe question was posed to me by my college director while I was bunking the class.I would like to ask this question from Failure with Nonvolatile Storage topic in portion Recovery System of Database Management

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment