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 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
Managing Multiuser Databases Locks placed by command are called ________ . shared locks implicit locks explicit locks exclusive locks shared locks implicit locks explicit locks exclusive locks 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? 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 refers to a cursor type where changes of any type and from any source are visible? Dynamic Forward only Static Keyset Dynamic Forward only Static Keyset ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases An ACID transaction is one that is atomic, consistent isolated, and durable. False True False True ANSWER DOWNLOAD EXAMIANS APP