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://rebrand.ly/lex-telegram-236dee

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;

Quick Links

Legal

Contact Info

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;

Quick Links

Legal

Contact Info

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;