If the transaction can no longer continue with its normal execution because of some internal condition, it is called as a _________(a) Logical error(b) System error(c) System crash(d) None of the mentionedThe question was posed to me in an online interview.My question is from Failure Classification and Storage topic in division Recovery System of RDBMS

If the transaction can no longer continue with its normal execution be

1.	If the transaction can no longer continue with its normal execution because of some internal condition, it is called as a _________(a) Logical error(b) System error(c) System crash(d) None of the mentionedThe question was posed to me in an online interview.My question is from Failure Classification and Storage topic in division Recovery System of RDBMS
Answer» The correct answer is (a) Logical error To elaborate: If the transaction can no LONGER continue with its NORMAL EXECUTION because of some internal condition, it is called as a logical error such as bad input, data not FOUND, OVERFLOW or resource limit exceeded.

Discussion

No Comment Found

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

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment