ExamQuestions.com

Register
Login
Oracle Database 11g Advanced PLSQL Exam Questions

Oracle

Oracle Database 11g Advanced PLSQL

68 / 68

Question 68:

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 waswritten into it. View the Exhibit. What is the reason for this? 
image

                
                
            
            
            
                

Answer options:

A. The PROC10 procedure is created with the invoker`s right.
B. The PROC10 procedure is not compiled with the DEBUG option.
C. Tracing is not enabled with the TRACE_ENABLED_CALLS option.
D. The TRACE_ENABLED parameter is set to FALSE for the session.