Database - Managing Multiuser Databases

Exercise : Managing Multiuser Databases - General Questions
11.
Dirty read, nonrepeatable, and phantom reads are not possible in this instance.
Read committed
Read uncommitted
Repeatable read
Serializable
Answer: Option
Explanation:
No answer description is available. Let's discuss.

12.
A transaction in which either all of the database actions occur or none of them do is called:
atomic.
consistent.
isolated.
durable.
Answer: Option
Explanation:
No answer description is available. Let's discuss.

13.
A cursor type in which the application can only move forward through the recordset is called:
forward only.
static.
keyset.
dynamic.
Answer: Option
Explanation:
No answer description is available. Let's discuss.

14.
Which of the following occurs when one transaction reads a changed record that has not been committed to the database?
Nonrepeatable read
Phantom read
Dirty read
Consistent read
Answer: Option
Explanation:
No answer description is available. Let's discuss.

15.
Which of the following allows dirty reads, nonrepeatable reads and phantom reads to occur?
Read committed
Read uncommitted
Repeatable read
Serializable
Answer: Option
Explanation:
No answer description is available. Let's discuss.