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
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. True False True False ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases Resource locking is a process to prevent multiple applications from obtaining copies of the same record when the record is about to be changed. False True False True ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases Locks placed by command are called ________ . explicit locks shared locks exclusive locks implicit locks explicit locks shared locks exclusive locks implicit locks ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases Which of the following disallows both dirty reads and nonrepeatable reads, but allows phantom reads? Repeatable read Read committed Serializable Read uncommitted Repeatable read Read committed Serializable Read uncommitted ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases A transaction is a series of actions to be taken on the database so that either all of them are performed successfully or none of them are performed at all. False True False True ANSWER DOWNLOAD EXAMIANS APP