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 : ?
A transaction is a series of actions to be taken on the database so that either all of them are performed successfully or none of them are performed at all.
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 : ?
The transaction log contains a copy of every database record (or page) after it has changed. These records are called before images.
YOUR ANSWER : ?
Locks placed by command are called ________ .
YOUR ANSWER : ?
Dirty read, nonrepeatable, and phantom reads are not possible in this instance.
YOUR ANSWER : ?
Locks placed by the DBMS are called ________ .
YOUR ANSWER : ?
The size of the lock is referred to as the lock granularity.
YOUR ANSWER : ?
Which of the following allows dirty reads, nonrepeatable reads and phantom reads to occur?
YOUR ANSWER : ?
In this instance, dirty reads are disallowed, while nonrepeatable reads and phantom reads are allowed.
YOUR ANSWER : ?