Managing Multiuser Databases Which of the following locks the item from access of any type? Exclusive lock Implicit lock Explicit lock Shared lock Exclusive lock Implicit lock Explicit lock Shared lock ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases Locks placed by the DBMS are called ________ . exclusive locks implicit locks shared locks explicit locks exclusive locks implicit locks shared locks explicit locks ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases The lost update problem is when User A reads data that have been processed by a portion of a transaction from User B. True False True False ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases Which of the following disallows both dirty reads and nonrepeatable reads, but allows phantom reads? Read committed Read uncommitted Serializable Repeatable read Read committed Read uncommitted Serializable Repeatable read 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
Managing Multiuser Databases Which of the following refers to a cursor type where changes of any type and from any source are visible? Forward only Dynamic Keyset Static Forward only Dynamic Keyset Static ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS