nerdexam
Oracle

1Z0-146 · Question #46

1Z0-146 Question #46: Real Exam Question with Answer & Explanation

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

Question

In a user session, tracing is enabled as follows: SQL> EXECUTE. DBMS_TRACE.SET_PLSQL_TRACE(DBMS_TRACE.TRACE_ENABLED_LINES); PL/SQL procedure successfully completed. You executed the procedure as follows: SQL> EXECUTE PROC10 PL/SQL procedure successfully completed. When you examine the PLSQL_TRACE_EVENTS table, you find that no trace information was written into it. View the Exhibit. What is the reason for this?

Exhibit

1Z0-146 question #46 exhibit

Options

  • AThe PROC10 procedure is created with the invoker's right.
  • BThe PROC10 procedure is not compiled with the DEBUG option.
  • CTracing is not enabled with the TRACE_ENABLED_CALLS option.
  • DThe TRACE_ENABLED parameter is set to FALSE for the session.

Unlock 1Z0-146 to see the answer

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