EXAMIANS
A transaction for which all committed changes are permanent is called:
YOUR 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?
YOUR ANSWER : ?
What is the overall responsibility of the DBA?
YOUR ANSWER : ?
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?
YOUR ANSWER : ?
Locks placed by command are implicit locks.
YOUR ANSWER : ?
When one transaction reads a changed record that has not been committed to the database a filthy read occurs.
YOUR ANSWER : ?
The size of the lock is referred to as the lock granularity.
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 : ?
Which of the following locks the item from access of any type?
YOUR ANSWER : ?
An exclusive lock locks the item from change but not from read.
YOUR ANSWER : ?