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 Consistent read Nonrepeatable read Phantom read Dirty read Consistent read Nonrepeatable read 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 a transaction rereads data and finds new rows that were inserted by a command transaction since the prior read? Phantom read Dirty read Consistent read Nonrepeatable read Phantom read Dirty read Consistent read Nonrepeatable read 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
Managing Multiuser Databases The goal of database security is to ensure that only authorized users can perform authorized activities at authorized times. 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? Serializable Read committed Repeatable read Read uncommitted Serializable Read committed Repeatable read Read uncommitted ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS