1Z0-060 · Question #114
1Z0-060 Question #114: Real Exam Question with Answer & Explanation
The correct answer is C: Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and. C:Setting the CONTROL_MANAGEMENT_PACK_ACCESS initialization parameter to DIAGNOSTIC+TUNING (default) enables monitoring of database operations. Real-Time SQL Monitoring is a feature of the Oracle Database Tuning Pack. The DBMS_SQL_MONITOR package provides information about Real-t
Question
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 TYPICAL and
- 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 monitored.
Explanation
C:Setting the CONTROL_MANAGEMENT_PACK_ACCESS initialization parameter to DIAGNOSTIC+TUNING (default) enables monitoring of database operations. Real-Time SQL Monitoring is a feature of the Oracle Database Tuning Pack. *The DBMS_SQL_MONITOR package provides information about Real-time SQL Monitoring and Real-time Database Operation Monitoring. *(not B)BEGIN_OPERATION Function starts a composite database operation in the current session. /(E)FORCE_TRACKING - forces the composite database operation to be tracked when the operation starts. You can also use the string variable 'Y'. / (not A)NO_FORCE_TRACKING - the operation will be tracked only when it has consumed at least 5 seconds of CPU or I/O time. You can also use the string variable 'N'.
Community Discussion
No community discussion yet for this question.