nerdexam
Oracle

1Z0-146 · Question #91

Examine the following structure: SQL> DESCRIBE user_identifiers Name Null? Type -------------------- ---------- ---------- NAME VARCHAR2(30) SIGNATURE VARCHAR2(32) TYPE VARCHAR2(18) OBJECT_NAME NOT…

The correct answer is A. an assignment made to VARIABLE B. declaration of a variable or formal parameter. Valid values in "Usage" are: Also, C&D are invalid because this dictionary doesn't provide data aboaut execution of

Debugging and Profiling PL/SQL Code

Question

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 Identify two scenarios in which information is stored in the USAGE column. (Choose two.)

Options

  • Aan assignment made to VARIABLE
  • Bdeclaration of a variable or formal parameter
  • Can identifier passed to a subprogram in IN OUT mode
  • Dexecution of the GOTO statement or raise of an exception

How the community answered

(38 responses)
  • A
    76% (29)
  • C
    8% (3)
  • D
    16% (6)

Explanation

Valid values in "Usage" are: Also, C&D are invalid because this dictionary doesn't provide data aboaut execution of

Topics

#PL/Scope#USER_IDENTIFIERS#identifier usage types#static code analysis

Community Discussion

No community discussion yet for this question.

Full 1Z0-146 Practice