Which lock should be obtained to prevent a concurrent transaction from executing a conflicting read, insert or delete operation on the same key value.(a) Higher-level lock(b) Lower-level lock(c) Read only lock(d) Read writeI have been asked this question by my school principal while I was bunking the class.Question is from Lock Release and Undo Operations in division Recovery System of Database Management

Which lock should be obtained to prevent a concurrent transaction from

1.	Which lock should be obtained to prevent a concurrent transaction from executing a conflicting read, insert or delete operation on the same key value.(a) Higher-level lock(b) Lower-level lock(c) Read only lock(d) Read writeI have been asked this question by my school principal while I was bunking the class.Question is from Lock Release and Undo Operations in division Recovery System of Database Management
Answer» Correct OPTION is (a) Higher-level lock To explain: Operations acquire lower-level locks while they execute, but RELEASE them when they COMPLETE; the CORRESPONDING transaction MUST however retain a higher-level lock in a two-phase manner to prevent concurrent transactions from executing conflicting actions.

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