Managing Multiuser Databases A transaction for which all committed changes are permanent is called: isolated. atomic. consistent. durable. isolated. atomic. consistent. durable. ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases Database administration refers to a function that applies to the entire organization. False True False True ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases A phantom read occurs when a transaction rereads data it has previously read and finds modifications or deletions caused by a committed transaction. False True False True 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? Dirty read Phantom read Consistent read Nonrepeatable read Dirty read Phantom read Consistent read Nonrepeatable read 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 Which of the following locks the item from access of any type? Implicit lock Exclusive lock Explicit lock Shared lock Implicit lock Exclusive lock Explicit lock Shared lock ANSWER DOWNLOAD EXAMIANS APP