Free 1Z0-117 Web TestEngine Demo

Q12 Single choice

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.

1Z0-117 Web TestEngine demo