nerdexam
Oracle

1Z0-054 · Question #143

1Z0-054 Question #143: Real Exam Question with Answer & Explanation

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

Question

Your database has the ACCTG service configured for an accounting application running on a middle tier. These service is used by the middle-tier applications to connect to the database by using connection pools. The application has three modules LEDGER, ACCOUNTS, and BILLING. You asked the developers to invoke the DBMS_APPLICATION_INFO.SET_MODULE procedure to set the module name and action in the code for the application. You enabled tracing at the service level by executing the following command: SQL> exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE('ACCTG'); You want to consolidate the trace output from the trace files created based on module. Which is the appropriate solution for this?

Options

  • AUsing trace files as input for the tkprof utility to consolidate the tracing of sessions for a module
  • BUsing the trace file as input for the trcsess utility to consolidate and process the output for a
  • CUsing the trcsess utility to consolidate all trace files into a single output file, which can then be
  • DUsing the trace file as input for the trcsess utility and creating output files that can directly be used

Unlock 1Z0-054 to see the answer

You've previewed enough free 1Z0-054 questions. Unlock 1Z0-054 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-054 Practice