Managing Multiuser Databases Which of the following locks the item from access of any type? Shared lock Implicit lock Exclusive lock Explicit lock Shared lock Implicit lock Exclusive lock Explicit lock ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases A durable transaction is one in which all committed changes are permanent. True False True False ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases Locks placed by the DBMS are called ________ . explicit locks shared locks implicit locks exclusive locks explicit locks shared locks implicit locks exclusive locks ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases Which of the following allows dirty reads, nonrepeatable reads and phantom reads to occur? Serializable Read uncommitted Repeatable read Read committed Serializable Read uncommitted Repeatable read Read committed 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 exclusive locks implicit locks shared locks explicit locks exclusive locks implicit locks shared locks ANSWER DOWNLOAD EXAMIANS APP