Your database has the SRV1 service configured for an ap

单项选择题

Your database has the SRV1 service configured for an application that runs on middle-tier application server. The application has multiple modules. You enable tracing at the service level by executing the following command:
SQL > exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE (‘SRV1’);
The possible outcome and actions to aggregate the trace files are as follows:
1. The command fails because a module name is not specified.
2. A trace file is created for each session that is running the SRV1 service.
3. An aggregated trace file is created for all the sessions that are running the SRV1 service.
4. The trace files may be aggregated by using the trcess utility.
5. The trace files be aggregated by using the tkprof utility.
Identify the correct outcome and the step to aggregate by using tkprof utility?（）

A. 1
B. 2 and 4
C. 2 and 5
D. 3 and 4
E. 3 and 5

相关考题

单项选择题 You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB) as a pluggable database (PDB). The characteristics of the non-CDB are as follows: -Version: Oracle Database 12c Releases 1 64-bit -Character set: WE8ISO8859P15 -National character set: AL16UTF16 -O/S: Oracle Linux 6 64-bit The characteristics of the CDB are as follows: -Version: Oracle Database 12c Release 1 64-bit -Character set: AL32UTF8 -O/S: Oracle Linux 6 64-bit Which technique should you use to minimize down time while plugging this non-CDB into the CDB?（）

多项选择题 Which three statements are true about the working of system privileges in a multitenant control database(CDB) that has pluggable databases (PDBs)?（）

多项选择题 Examine the commands executed to monitor database operations: $> conn sys oracle/oracle@prod as sysdba SQL > VAR eid NUMBER SQL > EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (‘batch_job’ , FORCED_TRACKING => ‘Y’); Which two statements are true?（）

1Z0-060