Examine the following structure:
SQL> DESCRIBE user_identifiers
Name Null? Type
—————————————– ——– ———————–
NAME VARCHAR2(30)
SIGNATURE VARCHAR2(32)
TYPE VARCHAR2(18)
OBJECT_NAME NOT NULL VARCHAR2(30)
OBJECT_TYPE VARCHAR2(13)
USAGE VARCHAR2(11)
USAGE_ID NUMBER
LINE NUMBER
COL NUMBER
USAGE_CONTEXT_ID NUMBER
Identify two scenarios in which information is stored in the USAGE column. (Choose two.)
A.
an assignment made to VARIABLE
B.
declaration of a variable or formal parameter
C.
an identifier passed to a subprogram in IN OUT mode
D.
execution of the GOTO statement or raise of an exception
A&B.
Valid values in “Usage” are:
REFERENCE
ASSIGNMENT
DECLARATION
DEFINITION
Also, C&D are invalid because this dictionary doesn’t provide data aboaut execution of procedure.
missig CALL
https://docs.oracle.com/cd/B28359_01/server.111/b28320/statviews_1089.htm#REFRN20599
A B
who can explain why c) is incorrect? formal paramter declaration doesn’t include IN OUT mode?
A, B
SYS views:
ALL_IDENTIFIERS displays information about the identifiers in the stored objects accessible to the current user.
DBA_IDENTIFIERS displays information about the identifiers in all stored objects in the database.
USER_IDENTIFIERS displays information about the identifiers in the stored objects owned by the current user.
This view does not display the OWNER column.
USAGE VARCHAR2(11), Type of the identifier usage:
– DECLARATION
– DEFINITION
– CALL
– REFERENCE
– ASSIGNMENT
https://docs.oracle.com/cd/B28359_01/server.111/b28320/statviews_1089.htm#REFRN20599