SOLVED: What will be the output on executing the below PL/SQL code snippet? DECLARE TYP ...

What will be the output on executing the below PL/SQL code snippet?

DECLARE
TYPE name_array IS VARRAY (5) OF VARCHAR2 (30);
v_name name_array := name_array('James', 'Thomas','Peter', 'Robb', 'Tom');
BEGIN
  DBMS_OUTPUT.PUT_LINE (v_name (1));
END;

James

Thomas

Error- Subscript outside of limit

Error -Reference to uninitialized collection

Verified Answer

Correct Option - a

To get all PLSQL Assessment Exam questions Join Telegram Group https://bit.ly/infy_premium_group

We're passionate about offering best placement materials and courses!! A one stop place for Placement Materials. We daily post Offcampus updates and Placement Materials.

Important Links

Privacy Policy

Refund Policy

Terms & Conditions

About Us

Contact Us

What will be the output on executing the below PL/SQL code snippet? DECLARE TYPE name_array IS VARRAY (5) OF VARCHAR2 (30); v_name name_array := name_array('James', 'Thomas','Peter', 'Robb', 'Tom'); BEGIN DBMS_OUTPUT.PUT_LINE (v_name (1)); END;

Important Links

What will be the output on executing the below PL/SQL code snippet?

DECLARE TYPE name_array IS VARRAY (5) OF VARCHAR2 (30); v_name name_array := name_array('James', 'Thomas','Peter', 'Robb', 'Tom'); BEGIN DBMS_OUTPUT.PUT_LINE (v_name (1)); END;