Managing Multiuser Databases In optimistic locking, the assumption is made that conflict will occur. False True False True ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases The size of a lock is called: shared lock exclusive lock lock granularity implicit lock shared lock exclusive lock lock granularity implicit lock ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases Locks placed by command are called ________ . explicit locks implicit locks exclusive locks shared locks explicit locks implicit locks exclusive locks shared locks ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases Locks placed by the DBMS are explicit locks. True False True False ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases The transaction log contains a copy of every database record (or page) after it has changed. These records are called before images. False True False True ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases Which of the following allows dirty reads, nonrepeatable reads and phantom reads to occur? Read committed Repeatable read Read uncommitted Serializable Read committed Repeatable read Read uncommitted Serializable ANSWER DOWNLOAD EXAMIANS APP