EXAMIANS
The advantage of optimistic locking is that:
YOUR ANSWER : ?
YOUR ANSWER : ?
Locks placed by command are implicit locks.
YOUR ANSWER : ?
In this instance, dirty reads are disallowed, while nonrepeatable reads and phantom reads are allowed.
YOUR ANSWER : ?
Which of the following allows dirty reads, nonrepeatable reads and phantom reads to occur?
YOUR ANSWER : ?
An exclusive lock locks the item from change but not from read.
YOUR ANSWER : ?
Which of the following refers to a cursor type where changes of any type and from any source are visible?
YOUR ANSWER : ?
A durable transaction is one in which all committed changes are permanent.
YOUR ANSWER : ?
A phantom read occurs when a transaction rereads data it has previously read and finds modifications or deletions caused by a committed transaction.
YOUR ANSWER : ?
A point of synchronization between the database and the transaction log is generally referred to as a stop point.
YOUR ANSWER : ?
A transaction for which all committed changes are permanent is called:
YOUR ANSWER : ?