A cursor type in which the application can only move forward through the recordset is called: forward only. static. dynamic. keyset. TRUE ANSWER : ? YOUR ANSWER : ?
Locks placed by the DBMS are called ________ . shared locks implicit locks exclusive locks explicit locks TRUE ANSWER : ? YOUR ANSWER : ?
The advantage of optimistic locking is that: transactions that are best suited are those with a lot of activity. the lock is obtained before the transaction has processed. the lock is obtained only after the transaction has processed. the lock never needs to be obtained. TRUE ANSWER : ? YOUR ANSWER : ?
A durable transaction is one in which all committed changes are permanent. True False TRUE ANSWER : ? YOUR ANSWER : ?
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. False True TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following disallows both dirty reads and nonrepeatable reads, but allows phantom reads? Serializable Read committed Repeatable read Read uncommitted TRUE ANSWER : ? YOUR ANSWER : ?
Dirty read, nonrepeatable, and phantom reads are not possible in this instance. Read committed Repeatable read Serializable Read uncommitted TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following refers to a cursor type where changes of any type and from any source are visible? Keyset Forward only Dynamic Static TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following occurs when one transaction reads a changed record that has not been committed to the database? Phantom read Dirty read Nonrepeatable read Consistent read TRUE ANSWER : ? YOUR ANSWER : ?