A cursor type in which the application sees the data as they were at the time the cursor was opened is called: forward only dynamic static keyset TRUE ANSWER : ? YOUR ANSWER : ?
A durable transaction is one in which all committed changes are permanent. False True TRUE ANSWER : ? YOUR ANSWER : ?
An exclusive lock locks the item from change but not from read. False True TRUE ANSWER : ? YOUR ANSWER : ?
In this instance, dirty reads are disallowed, while nonrepeatable reads and phantom reads are allowed. Read committed Repeatable read Read uncommitted Serializable 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? Nonrepeatable read Phantom read Consistent read Dirty read TRUE ANSWER : ? YOUR ANSWER : ?
The lost update problem is when User A reads data that have been processed by a portion of a transaction from User B. True False TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following refers to a cursor type where changes of any type and from any source are visible? Dynamic Forward only Keyset Static TRUE ANSWER : ? YOUR ANSWER : ?
Locks placed by command are called ________ . implicit locks explicit locks exclusive locks shared locks TRUE ANSWER : ? YOUR ANSWER : ?