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.
http://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_plscope.htm#ADFNS02206
A , C
B ,C i didn’t understood correctly question about A
PIERO is upstart
You didn`t understand correctly every question
B.
CREATE OR REPLACE FORCE VIEW SYS.USER_IDENTIFIERS
(
NAME,
SIGNATURE,
TYPE,
OBJECT_NAME,
OBJECT_TYPE,
USAGE,
USAGE_ID,
LINE,
COL,
USAGE_CONTEXT_ID
)
AS
SELECT i.symrep,
i.signature,
DECODE (i.type#,
1, ‘VARIABLE’,
2, ‘ITERATOR’,
3, ‘DATE DATATYPE’,
4, ‘PACKAGE’,
5, ‘PROCEDURE’,
6, ‘FUNCTION’,
7, ‘FORMAL IN’,
8, ‘SUBTYPE’,
9, ‘CURSOR’,
10, ‘INDEX TABLE’,
11, ‘OBJECT’,
12, ‘RECORD’,
13, ‘EXCEPTION’,
14, ‘BOOLEAN DATATYPE’,
15, ‘CONSTANT’,
16, ‘LIBRARY’,
17, ‘ASSEMBLY’,
18, ‘DBLINK’,
19, ‘LABEL’,
20, ‘TABLE’,
21, ‘NESTED TABLE’,
22, ‘VARRAY’,
23, ‘REFCURSOR’,
24, ‘BLOB DATATYPE’,
25, ‘CLOB DATATYPE’,
26, ‘BFILE DATATYPE’,
27, ‘FORMAL IN OUT’,
28, ‘FORMAL OUT’,
29, ‘OPAQUE DATATYPE’,
30, ‘NUMBER DATATYPE’,
31, ‘CHARACTER DATATYPE’,
32, ‘ASSOCIATIVE ARRAY’,
33, ‘TIME DATATYPE’,
34, ‘TIMESTAMP DATATYPE’,
35, ‘INTERVAL DATATYPE’,
36, ‘UROWID’,
37, ‘SYNONYM’,
38, ‘TRIGGER’,
‘UNDEFINED’),
o.name,
DECODE (o.type#,
5, ‘SYNONYM’,
7, ‘PROCEDURE’,
8, ‘FUNCTION’,
9, ‘PACKAGE’,
11, ‘PACKAGE BODY’,
12, ‘TRIGGER’,
13, ‘TYPE’,
14, ‘TYPE BODY’,
22, ‘LIBRARY’,
33, ‘SPEC OPERATOR’,
87, ‘ASSEMBLY’,
‘UNDEFINED’),
DECODE (a.action,
1, ‘DECLARATION’,
2, ‘DEFINITION’,
3, ‘CALL’,
4, ‘REFERENCE’,
5, ‘ASSIGNMENT’,
‘UNDEFINED’),
a.action#,
a.line,
a.col,
a.context#
FROM sys.”_CURRENT_EDITION_OBJ” o,
sys.plscope_identifier$ i,
sys.plscope_action$ a
WHERE i.signature = a.signature
AND o.obj# = a.obj#
AND ( o.type# IN (5, 7, 8, 9, 11, 12, 14, 22, 33, 87)
OR (o.type# = 13 AND o.subname IS NULL))
AND o.owner# = USERENV (‘SCHEMAID’);
C.
Identifier Types that PL/Scope Collects
Identifiers declared in compilation units that were not compiled with PLSCOPE_SETTINGS=’IDENTIFIERS:ALL’
do not appear in *_IDENTIFIER static data dictionary views.
http://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_plscope.htm#ADFNS02204