Managing Multiuser Databases When one transaction reads a changed record that has not been committed to the database a filthy read occurs. True False True False 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? Phantom read Dirty read Nonrepeatable read Consistent read Phantom read Dirty read Nonrepeatable read Consistent read ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases The size of a lock is called: lock granularity exclusive lock shared lock implicit lock lock granularity exclusive lock shared lock implicit lock ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases Resource locking is a process to prevent multiple applications from obtaining copies of the same record when the record is about to be changed. False True False True ANSWER DOWNLOAD EXAMIANS APP
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 Which of the following occurs when one transaction reads a changed record that has not been committed to the database? Phantom read Dirty read Nonrepeatable read Consistent read Phantom read Dirty read Nonrepeatable read Consistent read ANSWER DOWNLOAD EXAMIANS APP