Managing Multiuser Databases problems
- 1. Which of the following refers to a cursor type where changes of any type and from any source are visible?
Options- A. Forward only
- B. Static
- C. Keyset
- D. Dynamic Discuss
Correct Answer: Dynamic
- 2. Which of the following occurs when one transaction reads a changed record that has not been committed to the database?
Options- A. Nonrepeatable read
- B. Phantom read
- C. Dirty read
- D. Consistent read Discuss
Correct Answer: Dirty read
- 3. Which of the following occurs when a transaction rereads data and finds new rows that were inserted by a command transaction since the prior read?
Options- A. Nonrepeatable read
- B. Phantom read
- C. Dirty read
- D. Consistent read Discuss
Correct Answer: Phantom read
- 4. In this instance, dirty reads are disallowed, while nonrepeatable reads and phantom reads are allowed.
Options- A. Read committed
- B. Read uncommitted
- C. Repeatable read
- D. Serializable Discuss
Correct Answer: Read committed
- 5. The advantage of optimistic locking is that:
Options- A. the lock is obtained only after the transaction has processed.
- B. the lock is obtained before the transaction has processed.
- C. the lock never needs to be obtained.
- D. transactions that are best suited are those with a lot of activity. Discuss
Correct Answer: the lock is obtained only after the transaction has processed.
- 6. A transaction for which all committed changes are permanent is called:
Options- A. atomic.
- B. consistent.
- C. isolated.
- D. durable. Discuss
Correct Answer: durable.
- 7. A cursor type in which the application sees the data as they were at the time the cursor was opened is called:
Options- A. forward only.
- B. static.
- C. keyset.
- D. dynamic. Discuss
Correct Answer: static.
- 8. A cursor type in which the application can only move forward through the recordset is called:
Options- A. forward only.
- B. static.
- C. keyset.
- D. dynamic. Discuss
Correct Answer: forward only.
- 9. Locks placed by command are called ________ .
Options- A. implicit locks
- B. explicit locks
- C. exclusive locks
- D. shared locks Discuss
Correct Answer: explicit locks
- 10. Which of the following occurs when a transaction rereads data it has previously read and finds modification or deletions caused by a committed transaction?
Options- A. Nonrepeatable read
- B. Phantom read
- C. Dirty read
- D. Consistent read Discuss
Correct Answer: Nonrepeatable read
More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.