General Questions

Question 11 :

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


A). Read committed
B). Read uncommitted
C). Repeatable read
D). Serializable
Answer : Option D

Question 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.
Answer : Option A

Question 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.
Answer : Option A

Question 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
Answer : Option C

Question 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
Answer : Option B