Oracle
1Z0-063 · Question #19
1Z0-063 Question #19: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-063 to reveal the answer and full explanation for question #19. The question stem and answer options stay visible for context.
Question
Examine the commands executed to monitor database operations: $> conn sys/oracle@prod as sysdba SQL> VAR eid NUMBER SQL>EXEC :eid := DBMS_SQL_MONITOR.BEGlN_OPERATION('batch_job',FORCED_TRACKING=>'Y'); Which two statements are true?
Options
- ADatabase operations will be monitored only when they consume a significant amount of resource.
- BDatabase operations for all sessions will be monitored.
- CDatabase operations will be monitored only if the STATISTICS_LEVEL parameter is set to
- DOnly DML and DDL statements will be monitored for the session.
- EAll subsequent statements in the session will be treated as one database operation and will be
Unlock 1Z0-063 to see the answer
You've previewed enough free 1Z0-063 questions. Unlock 1Z0-063 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.