0 — Test 362
Page 1 of 3
Question 1
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 2
Serializable schedules are ones where ____________
0
System Administrator 2026
Question 3
A locking protocol is one that ____________
0
System Administrator 2026
Question 4
The two phase locking protocol consists of ____________
0
System Administrator 2026
Question 5
The growing phase is a phase in which?
0
System Administrator 2026
Question 6
The shrinking phase is a phase in which?
0
System Administrator 2026
Question 7
Which of the following concurrency control protocols ensure both conflict serializability and freedom from deadlock? I) 2-phase locking II) Timestamp ordering
0
System Administrator 2026
Question 8
A deadlock can be broken by ____________
0
System Administrator 2026
Question 9
The two ways of aborting processes and eliminating deadlocks are ____________
0
System Administrator 2026
Question 10
Those processes should be aborted on occurrence of a deadlock, the termination of which?
0
System Administrator 2026