Managing Multiuser Databases A cursor type in which the application sees the data as they were at the time the cursor was opened is called: keyset forward only static dynamic keyset forward only static dynamic ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases In this instance, dirty reads are disallowed, while nonrepeatable reads and phantom reads are allowed. Serializable Read uncommitted Repeatable read Read committed Serializable Read uncommitted Repeatable read Read committed 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. False True False True ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases Two transactions that run concurrently and generate results that are consistent with the results that would have occurred if they had run separately are referred to as serializable transactions. True False True False ANSWER DOWNLOAD EXAMIANS APP
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 Locks placed by the DBMS are called ________ . shared locks exclusive locks implicit locks explicit locks shared locks exclusive locks implicit locks explicit locks ANSWER DOWNLOAD EXAMIANS APP