Which option represents the sessions that can see the effect of the UPDATE and DELETE commands?

All database users are currently connected to the database instance and are working. The HR
user opens three database sessions and executes this command in one of the sessions:
SQL> UPDATE persons SET ccode=’U031′ WHERE ccode=’U029′;
123 rows updated.
SQL> DELETE FROM persons WHERE exp=’Y’;
3 rows deleted.
The SYS user opens a new session after HR executes the preceding commands. Which option
represents the sessions that can see the effect of the UPDATE and DELETE commands?

All database users are currently connected to the database instance and are working. The HR
user opens three database sessions and executes this command in one of the sessions:
SQL> UPDATE persons SET ccode=’U031′ WHERE ccode=’U029′;
123 rows updated.
SQL> DELETE FROM persons WHERE exp=’Y’;
3 rows deleted.
The SYS user opens a new session after HR executes the preceding commands. Which option
represents the sessions that can see the effect of the UPDATE and DELETE commands?

A.
all sessions of the HR user

B.
all sessions of the HR user and the SYS user

C.
the session of the HR user that executed the commands

D.
all sessions for which database users have access privileges to the PERSONS table



Leave a Reply 3

Your email address will not be published. Required fields are marked *


GandRalf

GandRalf

C

only local session is seeing updates until a commit is executed in these session