Atomic Transactions — Test 1
Page 1 of 2
Question 1
A collection of instructions that performs a single logical function is called ____________
0
System Administrator 2026
Question 2
A terminated transaction that has completed its execution successfully is ____________ otherwise it is __________
0
System Administrator 2026
Question 3
The state of the data accessed by an aborted transaction must be restored to what it was just before the transaction started executing. This restoration is known as ________ of transaction.
0
System Administrator 2026
Question 4
Write ahead logging is a way ____________
0
System Administrator 2026
Question 5
In the write ahead logging a _____________ is maintained.
0
System Administrator 2026
Question 6
An actual update is not allowed to a data item ____________
0
System Administrator 2026
Question 7
The undo and redo operations must be _________ to guarantee correct behaviour, even if a failure occurs during recovery process.
0
System Administrator 2026
Question 8
The system periodically performs checkpoints that consists of the following operation(s) ____________
0
System Administrator 2026
Question 9
Consider a transaction T1 that committed prior to checkpoint. The <T1 commits> record appears in the log before the <checkpoint> record. Any modifications made by T1 must have been written to the stable storage either with the checkpoint or prior to it. Thus at recovery time ____________
0
System Administrator 2026
Question 10
Serializable schedules are ones where ____________
0
System Administrator 2026