nerdexam
Oracle

1Z0-117 · Question #61

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

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

Question

Your database has the OLTP_SRV service configured for an OLTP application running on a middle tier. This service is used to connect to the database by using connection pools. The application has three modules. You enabled tracing at the service by executing the following command: SQL exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE (`OLTP_SRV'); What is the correct method of consolidating the trace files generated by the procedure?

Options

  • AUse all trace files as input for the tkprof utility to consolidate the trace files for a module.
  • BUse one trace file at a time as input for the trcess utility and use tkprof utility to consolidate all the output
  • CUse the trcess utility to consolidate all trace files into a single output file, which can then be processed by
  • DUse the tkprof utility to consolidate the trace files and create an output that can directly be used for diagnostic

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