nerdexam
Oracle

1Z0-146 · Question #151

Examine the code snippet from the declarative section of a PL/SQL block: DECLARE TYPE va1 IS VARRAY(10) OF VARCHAR2(20); SUBTYPE scale IS NUMBER(1,0); TYPE tb1 IS TABLE OF…

The correct answer is B. tb2 C. tb3. See the full explanation below for the reasoning.

Question

Examine the code snippet from the declarative section of a PL/SQL block:

DECLARE TYPE va1 IS VARRAY(10) OF VARCHAR2(20); SUBTYPE scale IS NUMBER(1,0); TYPE tb1 IS TABLE OF departments.department_name%TYPE INDEX BY departments.department_id%TYPE; TYPE tb2 IS TABLE OF va1 INDEX BY PLS_INTEGER; TYPE tb3 IS TABLE OF scale INDEX BY VARCHAR2(10); TYPE tb4 IS TABLE OF DATE INDEX BY DATE; TYPE tb5 IS TABLE OF NUMBER INDEX BY CHAR(2); .... Which of the above are valid definitions for associative arrays? (Choose all that apply.)

Options

  • Atb1
  • Btb2
  • Ctb3
  • Dtb4
  • Etb5

How the community answered

(44 responses)
  • A
    2% (1)
  • B
    77% (34)
  • D
    7% (3)
  • E
    14% (6)

Community Discussion

No community discussion yet for this question.

Full 1Z0-146 Practice