Database administration refers to a function that applies to the entire organization. False True TRUE ANSWER : ? YOUR ANSWER : ?
A transaction in which either all of the database actions occur or none of them do is called: atomic. consistent. isolated. durable. TRUE ANSWER : ? YOUR ANSWER : ?
A cursor type in which the application can only move forward through the recordset is called: static. forward only. dynamic. keyset. TRUE ANSWER : ? YOUR ANSWER : ?
An exclusive lock locks the item from change but not from read. True False TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following occurs when a transaction rereads data it has previously read and finds modification or deletions caused by a committed transaction? Consistent read Phantom read Nonrepeatable read Dirty read TRUE ANSWER : ? YOUR ANSWER : ?
The advantage of optimistic locking is that: the lock is obtained before the transaction has processed. transactions that are best suited are those with a lot of activity. the lock never needs to be obtained. the lock is obtained only after the transaction has processed. TRUE ANSWER : ? YOUR ANSWER : ?
The transaction log contains a copy of every database record (or page) after it has changed. These records are called before images. False True TRUE ANSWER : ? YOUR ANSWER : ?