Managing Multiuser Databases In optimistic locking, the assumption is made that conflict will occur. True False True False ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases The size of the lock is referred to as the lock granularity. True False True False ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases Locks placed by command are called ________ . implicit locks exclusive locks explicit locks shared locks implicit locks exclusive locks explicit locks shared locks 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 Which of the following occurs when one transaction reads a changed record that has not been committed to the database? Nonrepeatable read Dirty read Consistent read Phantom read Nonrepeatable read Dirty read Consistent read Phantom read 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