1Z0-052 · Question #108
All the database users are presently connected to the database instance and working. The HR user has opened three database sessions and executed the following command in one of his sessions: SQL> UPDA
Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #108. The question stem and answer options stay visible for context.
Question
All the database users are presently connected to the database instance and working. The HR user has opened three database sessions and executed the following command in one of his 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 executed the above commands. Which sessions can see the effect of the UPDATE and DELETE commands?
Options
- AAll sessions of the HR user only
- BAll sessions of the HR user and the SYS user
- CThe session of the HR user that executed the commands
- DAll the sessions for which the database users have access privilege to the PERSONS table
Unlock 1Z0-052 to see the answer
You've previewed enough free 1Z0-052 questions. Unlock 1Z0-052 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.