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. False True False True 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 A cursor type in which the application can only move forward through the recordset is called: dynamic. forward only. keyset. static. dynamic. forward only. keyset. static. ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases Which of the following refers to a cursor type that when the cursor is opened, a primary key value is saved for each row in the recordset; when the application accesses a row, the key is used to fetch the current values of the row? Dynamic Forward only Static Keyset Dynamic Forward only Static Keyset ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases A transaction for which all committed changes are permanent is called: isolated. consistent. atomic. durable. isolated. consistent. atomic. durable. ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases A point of synchronization between the database and the transaction log is generally referred to as a stop point. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS