Managing Multiuser Databases Dirty read, nonrepeatable, and phantom reads are not possible in this instance. Repeatable read Serializable Read committed Read uncommitted Repeatable read Serializable Read committed Read uncommitted ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases Which of the following occurs when a transaction rereads data it has previously read and finds modification or deletions caused by a committed transaction? Consistent read Phantom read Nonrepeatable read Dirty read Consistent read Phantom read Nonrepeatable read Dirty read ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases In optimistic locking, the assumption is made that conflict will occur. False True False True ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases A cursor type in which the application sees the data as they were at the time the cursor was opened is called: forward only static keyset dynamic forward only static keyset dynamic ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases A cursor type in which the application can only move forward through the recordset is called: dynamic. static. forward only. keyset. dynamic. static. forward only. keyset. ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases The lost update problem is when User A reads data that have been processed by a portion of a transaction from User B. False True False True ANSWER DOWNLOAD EXAMIANS APP