1. Which of the following best defines a transaction?
A transaction is a logical unit of work that must be entirely completed or entirely aborted
2. Which of the following is not a transaction property?
Completeness
3. Which of the following is NOT an event to end a transaction?
New SQL statement is reached.
4. Which of the following best defines inconsistent retrievals?
A concurrency control problem that arises when a transaction calculating summary functions over a set of data while other transactions are updating the same retrieved data.
5. Which of the following is NOT a valid lock level?
Column lock level
6. Which of the following statements best defines exclusive lock?
An exclusive lock exists when access is reserved specifically for the transaction that locked the object.
7. When do deadlocks occur?
When two transactions wait indefinitely for each other to unlock data
8. Which of the following allows dirty reads?
Read Uncommitted
9. Which of the following is not an event that can cause a database to stop working and compromise the integrity of the data?
Unauthorized access to database
10. Which of the following is NOT a valid technique to control deadlocks?
Deadlock abortion: all transactions are aborted for the requested object
Chapter 10 Use It
Your company is confused about the correct execution of two transactions and needs your technical assistance.
Analyze the table and select the correct answer.
| Time | Transaction | Step | Stored Value |
| 1 | T1 | READ COMPUTER_QOH | 25 |
| 2 | T1 | COMPUTER_QOH = 25 + 50 | |
| 3 | T1 | Question 1 | Question 2 |
| 4 | T1 | *******ROLLBACK******** | Question 3 |
| 5 | T2 | READ COMPUTER_QOH | |
| 6 | T2 | COMPUTER_QOH = 25 – 10 | |
| 7 | T2 | Question 4 | Question 5 |
‘WRITE COMPUTER_QOH
75
25
‘WRITE COMPUTER_QOH
15
Other Links:
See other websites for quiz:
Check on QUIZLET