PrepAway - Latest Free Exam Questions & Answers

which of the following is true for all other applications not running under the Uncommitted Read isolation lev

Application A issues the following SQL statements within in a single transaction using the
Uncommitted Read isolation level:
SELECT * FROM employee WHERE deptno=’A00′;
UPDATE employee SET salary = salary * 1.1 WHERE deptno=’A00′;
As long as the transaction has not been committed, which of the following is true for all other
applications not running under the Uncommitted Read isolation level?

PrepAway - Latest Free Exam Questions & Answers

A.
They can read and make changes to data for any employee in department A00.

B.
They can read but not make changes to data for any employee in department A00.

C.
They must wait until the transaction is committed before accessing data of any employee in
department A00.

D.
They must wait until application A disconnects before accessing data of any employee in
department A00.

One Comment on “which of the following is true for all other applications not running under the Uncommitted Read isolation lev


Leave a Reply