AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z0-146





Question ID 2837

Examine the following structure: SQL> DESCRIBE user_identifiers 

NAME VARCHAR2(30)
SIGNATURE VARCHAR2(32)
TYPE VARCHAR2(18)
OBJECT_NAME NOT NULL VARCHAR2(30)
OBJECT_TYPE VARCHAR2(13)
USAGE VARCHAR2(11)
USAGE_ID NUMBER
LINE NUMBER
Identify two scenarios in which information is stored in the USAGE column. (Choose two.)

Option A

A.    an assignment made to VARIABLE
 

Option B

B.    declaration of a variable or formal parameter
 

Option C

C.    an identifier passed to a subprogram in IN OUT mode
 

Option D

D.    execution of the GOTO statement or raise of an exception
 

Correct Answer A,B
Explanation


Question ID 2838

Examine the following settings for a session:
PLSQL_CODE_TYPE = NATIVE
View the Exhibit and examine the PL/SQL code.
You compile the program with the following attributes:
SQL> ALTER PROCEDURE proc1 COMPILE PLSQL_OPTIMIZE_LEVEL = 1;
Which statement is true about the execution of the PROC1 procedure in this scenario?
The following command is executed to start tracing in a user session:
SQL> EXECUTE
DBMS_TRACE.SET_PLSQL_TRACE(DBMS_TRACE.TRACE_ENABLED_EXCEPTIONS); Which statement is true about the effect of the command?
 

Option A

A.    It allows tracing of exceptions raised by all subprograms executed in the session.
 

Option B

B.    It allows tracing of user-defined exceptions raised by all subprograms executed in the session.
 

Option C

C.    It allows tracing of system-defined exceptions raised by all subprograms executed in the session.
 

Option D

D.    It allows tracing of exceptions raised by subprograms compiled with the DEBUG option and executed in the session.
 

Correct Answer D
Explanation

Send email to admin@getfreedumps for new dumps request!!!