A database supports three applications: CRM, ERP, and ACC. These applications connect to the database by using three different services: CRM_SRV for the CRM application, ERP_SRV for the ERP application, and ACC_SRV for the ACC application.
You enable tracing for the ACC_SRV service by issuing the following command:
SQL> EXECUTE DBMS for the ACC_SRV service by issuing the following command:
SQL> EXECUITIVE DBMS_MONITOR. SERV_MOD_ACT_TRACE_ENABLE (service_name => ‘ACC_SRV’, waits => TRUE, binds = > FALSE, instance_name = > ‘inst1’);
Which statement is true?
A. All trace information for the service connection to inst1 will be stored in a single trace file.
B. A trace file is not created because the module name is not specified.
C. A single trace file is created for each session that uses the ACC_SRV service.
D. Only those SQL statements that are identified with the ACC_SRV service executed on the inst1 instance are recorded in trace files.
E. All trace information for the ACC_SRV service connected to inst1 is stored in multiple trace files, which can be consolidated by using the tkprof utility.
|
Download Printable PDF. VALID exam to help you PASS. |
 |