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 2779

You executed the following command:
 
SQL> ALTER SESSION SET PLSCOPE
 
_SETTINGS = 'IDENTIFIERS:ALL';
 
You create a new package called PACK1. View Exhibit1 to examine the PL/SQL code for the
PACK1 package specification and body.
You issue the following query to see all unique identifiers with a name, such as %1:
SQL> SELECT NAME, SIGNATURE, TYPE
FROM USER_IDENTIFIERS
WHERE NAME LIKE '%1' AND USAGE='DECLARATION'
ORDER BY OBJECT_TYPE, USAGE_ID;
View Exhibit2 to examine the output of the query. Which two statements are true about the output
of the query? (Choose two.)

Option A

A.    The SIGNATURE column has a unique value for an identifier except for identifiers with the same name.
 

Option B

B.    The TYPE column has the value of packages, function or procedures, object types, PL/SQL types, triggers, or exceptions.
 

Option C

C.    The query shows the output for only those identifiers for PL/SQL objects, which are created by the user and are compiled after the ALTER SESSION command.
 

Option D

D.    The ALTER SESSION command automatically collects identifier data and the query shows the output for all the identifiers for PL/SQL objects, which are created by the user.
 

Correct Answer B,C
Explanation


Question ID 2780

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.
 

Option A

A.    The FOO procedure has been executed more than once.
 

Option B

B.    The PLSQL_DEBUG parameter is set to FALSE for the user session.
 

Option C

C.    The FOO procedure has been compiled with the DEBUG option, and executed.
 

Option D

D.    Schema level statistics have been gathered by the database administrator (DBA).
 

Correct Answer C
Explanation

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