Oracle
1Z0-146 · Question #11
You enabled PL/SQL tracing in a user session using the following command: SQL> EXECUTE DBMS_TRACE.SET_PLSQL_TRACE(DBMS_TRACE.TRACE_ALL_CALLS); View Exhibit1 to examine the output. After some time…
The correct answer is C. The FOO procedure has been compiled with the DEBUG option, and executed. See the full explanation below for the reasoning.
Question
You enabled PL/SQL tracing in a user session using the following command:
SQL> EXECUTE DBMS_TRACE.SET_PLSQL_TRACE(DBMS_TRACE.TRACE_ALL_CALLS); View Exhibit1 to examine the output. After some time, the query produces a different result as shown in Exhibit2. What is the cause for the change?
Exhibit
Options
- AThe FOO procedure has been executed more than once.
- BThe PLSQL_DEBUG parameter is set to FALSE for the user session.
- CThe FOO procedure has been compiled with the DEBUG option, and executed.
- DSchema level statistics have been gathered by the database administrator (DBA).
How the community answered
(62 responses)- A5% (3)
- B8% (5)
- C84% (52)
- D3% (2)
Community Discussion
No community discussion yet for this question.