Identify two scenarios in which information is stored in the USAGE column

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.)

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



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Leo Yu

Leo Yu

who can explain why C) is incorrect, IN OUT mode formal parameter is formal parameter as well.