Managing Multiuser Databases Which of the following disallows both dirty reads and nonrepeatable reads, but allows phantom reads? Read committed Serializable Read uncommitted Repeatable read Read committed Serializable Read uncommitted Repeatable read ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases Locks placed by command are called ________ . shared locks implicit locks exclusive locks explicit locks shared locks implicit locks exclusive locks explicit locks 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 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? Dirty read Phantom read Consistent read Nonrepeatable read Dirty read Phantom read Consistent read Nonrepeatable read ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases Which of the following refers to a cursor type where changes of any type and from any source are visible? Keyset Forward only Dynamic Static Keyset Forward only Dynamic Static 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
EXAMIANS