Oracle
1Z0-146 · Question #48
1Z0-146 Question #48: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-146 to reveal the answer and full explanation for question #48. The question stem and answer options stay visible for context.
Question
View the Exhibit and examine the structure of the EMPLOYEES table. Examine the following PL/SQL block: DECLARE TYPE EmpList IS VARRAY(2) OF employees.employee_id%TYPE NOT NULL; v_employees EmpList := EmpList(); BEGIN DBMS_OUTPUT.PUT_LINE(v_employees.COUNT); v_employees.EXTEND; v_employees(1) := 30; END; / Which statement is true about the outcome on executing the above PL/SQL block?
Exhibit
Options
- AIt executes successfully and displays the value 2.
- BIt executes successfully and displays the value 0.
- CIt generates an error because EXTEND cannot be used for varrays.
- DIt generates an error because the declaration of the varray is not valid.
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.