Choose all the correct options

Question

view the exhibit and examine the structure of the employees table. examine the following pl/sql block: declare type emplistis 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; g

Accepted Answer

It executes successfully and displays the value 0.

Answer

It executes successfully and displays the value 2.

Answer

It generates an error because EXTEND cannot be used for varrays.

Answer

It generates an error because the declaration of the varray is not valid.

View the Exhibit and examine the structure of the EMPLOYEES table. Examine the following PL/SQL block: DECLARE TYPE EmpListIS 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;

0 Discussions

Trending Exams