EXAMIANS
Which of the following occurs when one transaction reads a changed record that has not been committed to the database?
YOUR ANSWER : ?
YOUR ANSWER : ?
Which of the following disallows both dirty reads and nonrepeatable reads, but allows phantom reads?
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 : ?
Which of the following locks the item from access of any type?
YOUR ANSWER : ?
A transaction for which all committed changes are permanent is called:
YOUR ANSWER : ?
Locks placed by the DBMS are called ________ .
YOUR ANSWER : ?
Locks placed by command are called ________ .
YOUR ANSWER : ?
A cursor type in which the application sees the data as they were at the time the cursor was opened is called:
YOUR ANSWER : ?
An exclusive lock locks the item from change but not from read.
YOUR ANSWER : ?
Which of the following allows dirty reads, nonrepeatable reads and phantom reads to occur?
YOUR ANSWER : ?