A cursor type in which the application can only move forward through the recordset is called: forward only. dynamic. keyset. static. TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following allows dirty reads, nonrepeatable reads and phantom reads to occur? Read committed Read uncommitted Serializable Repeatable read TRUE ANSWER : ? YOUR ANSWER : ?
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 ANSWER : ? YOUR ANSWER : ?
In optimistic locking, the assumption is made that conflict will occur. False True TRUE ANSWER : ? YOUR ANSWER : ?
Dirty read, nonrepeatable, and phantom reads are not possible in this instance. Repeatable read Serializable Read committed Read uncommitted TRUE ANSWER : ? YOUR ANSWER : ?
Locks placed by the DBMS are called ________ . exclusive locks explicit locks implicit locks shared locks TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following locks the item from change but not from read? Explicit lock Exclusive lock Shared lock Implicit lock TRUE ANSWER : ? YOUR ANSWER : ?
The advantage of optimistic locking is that: the lock is obtained only after the transaction has processed. transactions that are best suited are those with a lot of activity. the lock is obtained before the transaction has processed. the lock never needs to be obtained. TRUE ANSWER : ? YOUR ANSWER : ?