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?
A.
Database operations will be monitored only when they consume a significant amount of
resource.
B.
Database operations for all sessions will be monitored.
C.
Database operations will be monitored only if the STATISTICS_LEVEL parameter is set
to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC +
TUNING.
D.
Only DML and DDL statements will be monitored for the session.
E.
All 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.
Note:
* 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’.
Answer: C,E
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.
Note:
* 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’.
QUESTION NO: 80
Examine the command:
$expdp SYSTEM FULL=YES DUMPFILE=dpump_dir1:fulll%U.dmp, dpump_dir2:full2% U.dmp,
dpump_dir3:full3%U.djnp FILESIZE=400M PARALLEL=3 JOB_NAME=expfull
Which statement is true about the execution of the command?
A. It fails because the log file parameter is not specified.
B. It fails because no absolute path is specified for the log file and dump file.
C. It succeeds and exports the full database, simultaneously creating three copies of dump files at
three different locations.
D. It succeeds and exports the full database, simultaneously creating three dump files at three
different locations, but the total number of dump files can exceed three.
Answer: B
Explanation:
QUESTION NO: 81
Oracle 1z0-067 Exam
“Pass
Thanks IS IT CORRECT?
It’s complicated for me :((
C is here
Enabling Monitoring of Database Operations at the System Level
The SQL monitoring feature is enabled by default when the STATISTICS_LEVEL initialization parameter is either set to TYPICAL (the default value) or ALL. SQL monitoring starts automatically for all long-running queries.
Prerequisites
Because SQL monitoring is a feature of the Oracle Database Tuning Pack, the CONTROL_MANAGEMENT_PACK_ACCESS initialization parameter must be set to DIAGNOSTIC+TUNING (the default value).
https://docs.oracle.com/database/121/TGSQL/tgsql_monit.htm#TGSQL94600
E is here
FORCED_TRACKING : When set to the constant FORCE_TRACKING (Y), the operation is tracked. When set to NO_FORCE_TRACKING (N), the default, the operation is only tracked if it has consumed 5 seconds of CPU or I/O time.
https://oracle-base.com/articles/12c/real-time-database-operation-monitoring-12cr1
CE
CE