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

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.

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.

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

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

Leave A Comment?

6 − two =