Oracle
1Z0-497 · Question #117
1Z0-497 Question #117: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-497 to reveal the answer and full explanation for question #117. The question stem and answer options stay visible for context.
Question
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?
Options
- Aall sessions of the HR user
- Ball sessions of the HR user and the SYS user
- Cthe session of the HR user that executed the commands
- Dall sessions for which database users have access privileges to the PERSONS table
Unlock 1Z0-497 to see the answer
You've previewed enough free 1Z0-497 questions. Unlock 1Z0-497 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.