Question 1

Database transaction _____ restores a database from an inconsistent state to a previously consistent state.

Accepted Answer

The answer of Database transaction _____ restores a database from...

Question 2

A(n) ______ occurs when a transaction executes a query at time T1, and it runs the same query at same time T2, yielding additional rows that satisfy the query.

Accepted Answer

The answer of A(n) ______ occurs when a transaction executes...

Question 3

In a heavily used database management system (DBMS), the prevention and detection of _____ constitutes an important DBMS function.

Accepted Answer

The answer of In a heavily used database management system...

Question 4

What are database checkpoints?

Accepted Answer

The answer of What are database checkpoints?...

Question 5

The _____ rule states that only one transaction at a time can own an exclusive lock on the same object.

Accepted Answer

The answer of The _____ rule states that only one...

Question 6

The DBMS uses the information stored in the _____log for a recovery requirement triggered by a ROLLBACK statement, a program's abnormal termination, or a system failure such as a network discrepancy or a disk crash.

Accepted Answer

The answer of The DBMS uses the information stored in...

Question 7

What are the three basic techniques to control deadlocks?

Accepted Answer

The answer of What are the three basic techniques to...

Question 8

As a rule, a(n) _____ must unlock the object after its termination.

Accepted Answer

The answer of As a rule, a(n) _____ must unlock...

Question 9

What is transaction isolation and why it is important?

Accepted Answer

The answer of What is transaction isolation and why it...

Question 10

_____ ensure that a disk physical failure will not impair the DBMS's ability to recover data.

Accepted Answer

The answer of _____ ensure that a disk physical failure...

Question 11

If T1 has not unlocked data item Y, T2 cannot begin; if T2 has not unlocked data item X, T1 cannot continue. Consequently, T1 and T2 each wait for the other to unlock the required data item. Such a deadlock is also known as a(n) _____.

Accepted Answer

The answer of If T1 has not unlocked data item...

Question 12

Uniqueness ensures that no equal time stamp values can exist, and _____ ensures that time stamp values always increase.

Accepted Answer

The answer of Uniqueness ensures that no equal time stamp...

Question 13

The _____ protocol ensures that transaction logs are always written before any database data is actually updated.

Accepted Answer

The answer of The _____ protocol ensures that transaction logs...

Question 14

How does a shared/exclusive lock schema increase the lock manager's overhead?

Accepted Answer

The answer of How does a shared/exclusive lock schema increase...

Quiz 10: Transaction Management and Concurrency Control