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 dynamic static forward only keyset dynamic static forward only ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases The size of the lock is referred to as the lock granularity. False True False True ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases What is the overall responsibility of the DBA? Development, operation, and maintenance of the database and its applications Facilitate the development and use of the database Create and populate tables Both the first and third answers above are correct. Development, operation, and maintenance of the database and its applications Facilitate the development and use of the database Create and populate tables Both the first and third answers above are correct. ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases The advantage of optimistic locking is that: the lock is obtained before the transaction has processed. the lock never needs to be obtained. transactions that are best suited are those with a lot of activity. the lock is obtained only after the transaction has processed. the lock is obtained before the transaction has processed. the lock never needs to be obtained. transactions that are best suited are those with a lot of activity. the lock is obtained only after the transaction has processed. ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases A transaction is a series of actions to be taken on the database so that either all of them are performed successfully or none of them are performed at all. True False True False ANSWER DOWNLOAD EXAMIANS APP
Managing Multiuser Databases An exclusive lock locks the item from change but not from read. False True False True ANSWER DOWNLOAD EXAMIANS APP