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

Comments

No comments yet. Why don’t you start the discussion?

    Leave a Reply

    Your email address will not be published. Required fields are marked *

    20 − 16 =