To perform logical redo or undo, the database state on disk must be operation ___________ that is, it should not have partial effects of any operation.(a) Persistent(b) Resistant(c) Consistent(d) None of the mentionedThis question was addressed to me in unit test.My question comes from Lock Release and Undo Operations topic in chapter Recovery System of Database Management

To perform logical redo or undo, the database state on disk must be op

1.	To perform logical redo or undo, the database state on disk must be operation ___________ that is, it should not have partial effects of any operation.(a) Persistent(b) Resistant(c) Consistent(d) None of the mentionedThis question was addressed to me in unit test.My question comes from Lock Release and Undo Operations topic in chapter Recovery System of Database Management
Answer» CORRECT CHOICE is (c) Consistent Easy explanation - Data STRUCTURES such as B+-trees WOULD not be in a consistent state, and neither logical redo nor logical undo operations can be PERFORMED on an inconsistent data structure.

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