nerdexam
Oracle

1Z0-117 · Question #124

1Z0-117 Question #124: Real Exam Question with Answer & Explanation

Sign in or unlock 1Z0-117 to reveal the answer and full explanation for question #124. The question stem and answer options stay visible for context.

Question

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?

Options

  • AAll trace information for the service connection to inst1 will be stored in a single trace file.
  • BA trace file is not created because the module name is not specified.
  • CA single trace file is created for each session that uses the ACC_SRV service.
  • DOnly those SQL statements that are identified with the ACC_SRV service executed on the inst1
  • EAll trace information for the ACC_SRV service connected to inst1 is stored in multiple trace files,

Unlock 1Z0-117 to see the answer

You've previewed enough free 1Z0-117 questions. Unlock 1Z0-117 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full 1Z0-117 Practice