Managing Multiuser Databases Which of the following locks the item from change but not from read? Shared lock Implicit lock Explicit lock Exclusive lock Shared lock Implicit lock Explicit lock Exclusive lock 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? Phantom read Dirty read Nonrepeatable read Consistent read Phantom read Dirty read Nonrepeatable read Consistent read ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases An exclusive lock locks the item from change but not from read. False True False True ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases In this instance, dirty reads are disallowed, while nonrepeatable reads and phantom reads are allowed. Serializable Read uncommitted Repeatable read Read committed Serializable Read uncommitted Repeatable read Read committed ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases Which of the following locks the item from access of any type? Explicit lock Implicit lock Shared lock Exclusive lock Explicit lock Implicit lock Shared lock Exclusive lock ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases Dirty read, nonrepeatable, and phantom reads are not possible in this instance. Repeatable read Serializable Read uncommitted Read committed Repeatable read Serializable Read uncommitted Read committed ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS