Oracle
1Z0-146 · Question #151
1Z0-146 Question #151: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-146 to reveal the answer and full explanation for question #151. The question stem and answer options stay visible for context.
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
Unlock 1Z0-146 to see the answer
You've previewed enough free 1Z0-146 questions. Unlock 1Z0-146 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.