<< Prev Question Next Question >>
Question 4/47
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.)
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.)
