ExamQuestions.com

Register
Login
Oracle Database 11g Advanced PLSQL Exam Questions

Oracle

Oracle Database 11g Advanced PLSQL

54 / 68

Question 54:

See the Exhibit: Exhibit1 - 
image
Exhibit2 - 
image
You execute the following command: 
image
You create a new package called PACK. Examine the PL/SQL code in exhibit for the PACK1 package specification and body. You issue the following query to see all unique identifiers with a name, such as %1: 
image
View the exhibit 2 to examine the output of the query. Which two statements are true about the output of the query? (Choose two.) 

Answer options:

A. The SIGNATURE column has a unique value for an identifier except for identifiers with the same name
B. The TYPE column has the value of packages, function or procedures, object types, PL/SQL types, triggers or exceptions
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
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