Managing Multiuser Databases
Which of the following occurs when a transaction rereads data and finds new rows that were inserted by a command transaction since the prior read?

Consistent read
Dirty read
Phantom read
Nonrepeatable read

ANSWER DOWNLOAD EXAMIANS APP

Managing Multiuser Databases
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 never needs to be obtained.
the lock is obtained before the transaction has processed.

ANSWER DOWNLOAD EXAMIANS APP