Related InterviewSolutions

• If the database modifications occur while the transaction is still active, the transaction is said to use the __________ modification technique(a) Deferred(b) Immediate(c) More than one of the mentioned(d) None of the mentionedI got this question in an internship interview.The above asked question is from Recovery and Atomicity in section Recovery System of RDBMS
• A __________ checkpoint is a checkpoint where transactions are allowed to perform updates even while buffer blocks are being written out.(a) Temporary(b) Fuzzy(c) Permanent(d) RecoveryThe question was asked during an internship interview.Query is from Recovery and Atomicity topic in division Recovery System of RDBMS
• State true or false: Using checkpoints reduces overhead(a) True(b) FalseThis question was posed to me at a job interview.This intriguing question originated from Recovery and Atomicity topic in division Recovery System of RDBMS
• We say that a transaction has been ________ when its commit log record has been output to stable storage.(a) Locked(b) Completed(c) Committed(d) ReleasedThis question was posed to me by my school teacher while I was bunking the class.Asked question is from Recovery and Atomicity topic in chapter Recovery System of RDBMS
• If a transaction does not modify the database until it has committed it is said to use a_______ modification technique(a) Deferred(b) Immediate(c) More than one of the mentioned(d) None of the mentionedI had been asked this question during an interview for a job.This interesting question is from Recovery and Atomicity in portion Recovery System of RDBMS
• The value of the data item prior to the write is called as _________(a) Transaction identifier(b) Data-item identifier(c) Old value(d) New valueThis question was posed to me during an internship interview.My question is from Recovery and Atomicity in section Recovery System of RDBMS
• The unique identifier of the transaction that performed the write operation is called as _______(a) Transaction identifier(b) Data-item identifier(c) Old value(d) New valueThe question was asked during an interview.The question is from Recovery and Atomicity in chapter Recovery System of RDBMS
• Which of the following fields does the update log record have?(a) Transaction identifier(b) Data-item identifier(c) Old value(d) All of the mentionedI had been asked this question during an interview.This key question is from Recovery and Atomicity in chapter Recovery System of RDBMS
• An update log record describes a ________ database write(a) Single(b) Double(c) Triple(d) QuadrupleI got this question during an interview.The origin of the question is Recovery and Atomicity in section Recovery System of RDBMS
• The most widely used structure for recording database modification is called as _______(a) Log(b) List(c) Queue(d) StackThis question was posed to me in an interview for job.This intriguing question originated from Recovery and Atomicity topic in chapter Recovery System of RDBMS