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
who can explain why C) is incorrect, IN OUT mode formal parameter is formal parameter as well.
A, B