Examine these commands which execute successfully in the sequence shown in Sessions S1 and S2:
Now, examine this statement that execute successfully in s1:
S1> SELECT * FROM emp;
Which is true about the result of the select statement?
The inserted row is returned because the transaction is auto committed in S2.
The inserted row is not returned because the isolation level is READ COMMITTED in S2.
The inserted row is not returned because the transaction still active in s2.
The inserted row is returned because the isolation level is RPEATABLE READ in S1.
Submit