Managing Multiuser Databases The size of the lock is referred to as the lock granularity. 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: keyset static forward only dynamic keyset static forward only dynamic ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases When one transaction reads a changed record that has not been committed to the database a filthy read occurs. False True False True 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 Dirty read Nonrepeatable read Consistent read Phantom read Dirty read Nonrepeatable read ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases A transaction in which either all of the database actions occur or none of them do is called: atomic. durable. consistent. isolated. atomic. durable. consistent. isolated. ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases Which of the following occurs when a transaction rereads data and finds new rows that were inserted by a command transaction since the prior read? Dirty read Phantom read Consistent read Nonrepeatable read Dirty read Phantom read Consistent read Nonrepeatable read ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS