Question 1

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

Accepted Answer

A)   time
B)   practical
C)   logical
D)   physicalE) B) and D)
F) B) and C)

Question 2

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 3

What are database checkpoints?

Accepted Answer

Database checkpoints are operations in w...

Question 4

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 5

_____ 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 problemsE) C) and D)
F) None of the above

Question 6

Lock _____ indicates the level of lock use.

Accepted Answer

A)   granularity
B)   shrinking
C)   growing
D)   serializabilityE) A) and B)
F) All of the above

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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 9

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.E) None of the above
F) B) and C)

Question 10

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 E) C) and D)
F) A) and B)

Question 11

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 12

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 13

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

Accepted Answer

Redundant ...

Question 14

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 15

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.E) None of the above
F) A) and D)

Question 16

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

Accepted Answer

A)   transaction
B)   database
C)   lock
D)   scheduleE) B) and D)
F) All of the above

Question 17

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

Accepted Answer

A)   Locks
B)   Schedules
C)   Stamps
D)   LogsE) B) and D)
F) All of the above

Question 18

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-phaseE) B) and D)
F) B) and C)

Question 19

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.E) A) and B)
F) None of the above

Question 20

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

Exam 10: Transaction Management and Concurrency Control

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.

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

Lock _____ indicates the level of lock use.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

What are database checkpoints?

Correct AnswerverifiedDatabase checkpoints are operations in w...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedRedundant ...View AnswerShow Answer

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.

Correct AnswerverifiedShow Answer

What rule applies to the two-phase locking protocol?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

In the wait/die scheme, the:

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Database checkpoints are operations in w...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Redundant ...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified