Managing Multiuser Databases The size of a lock is called: exclusive lock lock granularity implicit lock shared lock exclusive lock lock granularity implicit lock shared lock ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases Database administration refers to a function that applies to the entire organization. True False True False ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases A transaction for which all committed changes are permanent is called: isolated. consistent. atomic. durable. isolated. consistent. atomic. durable. 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. 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? Nonrepeatable read Consistent read Dirty read Phantom read Nonrepeatable read Consistent read Dirty read Phantom read ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases The transaction log contains a copy of every database record (or page) after it has changed. These records are called before images. True False True False ANSWER DOWNLOAD EXAMIANS APP