EXAMIANS
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 : ?
YOUR ANSWER : ?
The transaction log contains a copy of every database record (or page) after it has changed. These records are called before images.
YOUR ANSWER : ?
When two transactions are being processed against the database at the same time they are termed concurrent transactions.
YOUR ANSWER : ?
When one transaction reads a changed record that has not been committed to the database a filthy read occurs.
YOUR ANSWER : ?
Which of the following occurs when one transaction reads a changed record that has not been committed to the database?
YOUR ANSWER : ?
Dirty read, nonrepeatable, and phantom reads are not possible in this instance.
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 : ?
Locks placed by the DBMS are explicit locks.
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 : ?
What is the overall responsibility of the DBA?
YOUR ANSWER : ?