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.)
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 created by the user.
Explanation:
USER_IDENTIFIERS is a new view as of 11g, USER_IDENTIFIERS displays information about the identifiers in the stored objects owned by the current userColumn
Owner Owner of the identifier
NAME Name of the identifier
SIGNATURE Signature of the identifier
TYPE Type of the identifier
(packages, function or procedures, object types, PL/SQL types, triggers, or exceptions.)
OBJECT_NAME Name of the object where the identifier action occurred
OBJECT_TYPE Type of the object where the identifier action occurred
USAGE Type of the identifier usage:
DECLARATION
DEFINITION
CALL
REFERENCE
ASSIGNMENT
USAGE_ID unique key for the identifier usage within the object
LINE Line number of the identifier action
COL Column number of the identifier action
USAGE_CONTEXT_ID Context USAGE_ID of the identifier usage
B,c
??