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? Dirty read Consistent read Nonrepeatable read Phantom read Dirty read Consistent read Nonrepeatable read Phantom read 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? Phantom read Dirty read Nonrepeatable read Consistent read Phantom read Dirty read Nonrepeatable read Consistent read ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases A point of synchronization between the database and the transaction log is generally referred to as a stop point. False True False True 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 A durable transaction is one in which all committed changes are permanent. False True False True ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases Which of the following disallows both dirty reads and nonrepeatable reads, but allows phantom reads? Read uncommitted Serializable Repeatable read Read committed Read uncommitted Serializable Repeatable read Read committed ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS