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.
B, C