Question 1

_____ occurs when a transaction accesses data before and after one or more other transactions finish working with such data.

Accepted Answer

A)  Inconsistent retrieval 
B)  The phenomena of uncommitted data 
C)  Lost update problems 
D)  Dirty read problems

Question 2

What are database checkpoints?

Accepted Answer

The answer of What are database checkpoints?...

Question 3

When using an optimistic approach, during the read phase, a transaction reads the database, executes the needed computations, and makes the updates to a private copy of the database values.

Accepted Answer

A) True 
 B)False

Question 4

The multiuser DBMS must implement controls to ensure serializability and isolation of transactions, in addition to atomicity and durability, in order to guard the database's consistency and integrity.

Accepted Answer

A) True 
 B)False

Question 5

_____ are required to prevent another transaction form reading inconsistent data.

Accepted Answer

A)  Locks 
B)  Schedules 
C)  Stamps 
D)  Logs

Question 6

_____ 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 7

The _____ occurs when two concurrent transactions, T1 and T2, are updating the same data element and one of the updates is lost.

Accepted Answer

The answer of The _____ occurs when two concurrent transactions,...

Question 8

Lock _____ indicates the level of lock use.

Accepted Answer

A)  granularity 
B)  shrinking 
C)  growing 
D)  serializability

Question 9

Of the following events, which is defined by ANSI as being equivalent to a ROLLBACK?

Accepted Answer

A)  Five SQL statements are executed. 
B)  The end of a program is successfully reached. 
C)  All changes are aborted and returned to a previous consistent state. 
D)  The database is shut down for maintenance.

Question 10

The phenomenon of uncommitted data occurs when two transactions are executed concurrently and the first transaction is rolled back after the second transaction has already accessed the uncommitted data-thus violating the isolation property of transactions.

Accepted Answer

A) True 
 B)False

Question 11

The _____ manager is responsible for assigning and policing the locks used by transactions.

Accepted Answer

A)  transaction 
B)  database 
C)  lock 
D)  schedule

Question 12

A(n) _____ lock exists when concurrent transactions are granted read access on the basis of a common lock.

Accepted Answer

A)  shared 
B)  exclusive 
C)  binary 
D)  two-phase

Question 13

The _____ approach to scheduling concurrent transactions assigns a global unique stamp to each transaction.

Accepted Answer

A)  scheduled 
B)  table-locking 
C)  unique 
D)  time stamping

Question 14

The serializable isolation level is the least restrictive level defined by the ANSI SQL standard.

Accepted Answer

A) True 
 B)False

Question 15

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 16

What rule applies to the two-phase locking protocol?

Accepted Answer

A)  Two transactions cannot have conflicting lock. 
B)  No unlock operation can precede a lock operation in a different transaction. 
C)  No data is affected until all locks are released. 
D)  No data is affected until the transaction is in its locked position.

Question 17

Transaction is a _____ unit of work that must be either entirely completed or aborted.

Accepted Answer

A)  time 
B)  practical 
C)  logical 
D)  physical

Question 18

Although the DBMS is designed to recover a database to a previous consistent state when an interruption prevents the completion of a required set of transactions, the transactions themselves are defined by the end user or programmer and must be semantically correct.

Accepted Answer

A) True 
 B)False

Question 19

In the wait/die scheme, the:

Accepted Answer

A)  older transaction rolls back the younger transaction and reschedules it. 
B)  younger, preempted transaction is rescheduled using the same time stamp. 
C)  older transaction waits for the younger one to complete and release its locks. 
D)  younger and older transactions both wait indefinitely to be released.

Question 20

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...

Exam 10: Transaction Management and Concurrency Control

_____ occurs when a transaction accesses data before and after one or more other transactions finish working with such data.

What are database checkpoints?

When using an optimistic approach, during the read phase, a transaction reads the database, executes the needed computations, and makes the updates to a private copy of the database values.

The multiuser DBMS must implement controls to ensure serializability and isolation of transactions, in addition to atomicity and durability, in order to guard the database's consistency and integrity.

_____ are required to prevent another transaction form reading inconsistent data.

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

The _____ occurs when two concurrent transactions, T1 and T2, are updating the same data element and one of the updates is lost.

Lock _____ indicates the level of lock use.

Of the following events, which is defined by ANSI as being equivalent to a ROLLBACK?

The phenomenon of uncommitted data occurs when two transactions are executed concurrently and the first transaction is rolled back after the second transaction has already accessed the uncommitted data-thus violating the isolation property of transactions.

The _____ manager is responsible for assigning and policing the locks used by transactions.

A(n) _____ lock exists when concurrent transactions are granted read access on the basis of a common lock.

The _____ approach to scheduling concurrent transactions assigns a global unique stamp to each transaction.

The serializable isolation level is the least restrictive level defined by the ANSI SQL standard.

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.

What rule applies to the two-phase locking protocol?

Transaction is a _____ unit of work that must be either entirely completed or aborted.

Although the DBMS is designed to recover a database to a previous consistent state when an interruption prevents the completion of a required set of transactions, the transactions themselves are defined by the end user or programmer and must be semantically correct.

In the wait/die scheme, the:

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) _____.