nerdexam
Oracle

1Z0-054 · Question #142

Your database has the ACCTG service configured for an accounting application that runs on a middle tier. The application has three modules LEDGER, ACCOUNTS, and BILLING. You enabled tracing at the…

The correct answer is D. A trace file is created for each session that uses the service, regardless of the module and action. See the full explanation below for the reasoning.

Question

Your database has the ACCTG service configured for an accounting application that runs on a middle tier. The application has three modules LEDGER, ACCOUNTS, and BILLING. You enabled tracing at the service level by executing the following command:

SQL> exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE('ACCTG'); Which statement is true?

Options

  • AA single trace file would be created for all the sessions for the service.
  • BThree trace files would be created for the three modules in the application.
  • CThe trace file would not be created because the module name is not specified.
  • DA trace file is created for each session that uses the service, regardless of the module and action.

How the community answered

(20 responses)
  • A
    5% (1)
  • B
    5% (1)
  • C
    10% (2)
  • D
    80% (16)

Community Discussion

No community discussion yet for this question.

Full 1Z0-054 Practice