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

Correct Answer for the Question – Which option represents the sessions that can see the effect of the UPDATE and DELETE commands? is given below

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?Without issue of commit by the HR user, the other users are unable to see the changes even though they have access.

all sessions of the HR user

all sessions of the HR user and the SYS user

the session of the HR user that executed the commands

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

Correct Answer

The Correct Answer for this Question is

the session of the HR user that executed the commands

Explanation

The Question – Which option represents the sessions that can see the effect of the UPDATE and DELETE commands? has been answered correctly and answers for the question is the session of the HR user that executed the commands

More about these Exams

These Exam Questions and the order of these questions keep changing. but the answers are obviously same. so if you don’t find a question after another we suggest you search it in the search box and we are sure you’ll find it. you can bookmark this site for Quick access in future.

We hope you found it helpful don’t forget to leave a comment if you feel a need to correct or ask we’re always here to help.

you can find more here at Certout

Feel free to contact via comment or email.

Happy Learning

Cheers, Team Certout

Leave a Comment