Managing Multiuser Databases – General Questions

11. Dirty read, nonrepeatable, and phantom reads are not possible in this instance.

A. Read committed
B. Read uncommitted
C. Repeatable read
D. Serializable

Correct Answer:  D. Serializable
Advertisement

12. A transaction in which either all of the database actions occur or none of them do is called:

A. atomic.
B. consistent.
C. isolated.
D. durable.

Correct Answer:  A. atomic.
Advertisement

13. A cursor type in which the application can only move forward through the recordset is called:

A. forward only.
B. static.
C. keyset.
D. dynamic

Correct Answer:  A. forward only.
Advertisement

14. Which of the following occurs when one transaction reads a changed record that has not been committed to the database?

A. Nonrepeatable read
B. Phantom read
C. Dirty read
D. Consistent read

Correct Answer:  C. Dirty read
Advertisement

15. Which of the following allows dirty reads, nonrepeatable reads and phantom reads to occur?

A. Read committed
B. Read uncommitted
C. Repeatable read
D. Serializable

Correct Answer:  B. Read uncommitted
Advertisement

Leave A Comment?