Managing Multiuser Databases Which of the following allows dirty reads, nonrepeatable reads and phantom reads to occur? Serializable Read uncommitted Read committed Repeatable read Serializable Read uncommitted Read committed Repeatable read ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases In this instance, dirty reads are disallowed, while nonrepeatable reads and phantom reads are allowed. Repeatable read Read uncommitted Read committed Serializable Repeatable read Read uncommitted Read committed Serializable 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. True False True False ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases A transaction for which all committed changes are permanent is called: durable. isolated. consistent. atomic. durable. isolated. consistent. atomic. 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 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