Oracle Database Advanced PL SQL 12c 1z0 148

Question : 32 of 54

Marks: +1, -0

Examine this code:

CREATE TYPE list_typ IS TABLE OF NUMBER; 
 / 
 DECLARE 
 l_list list_typ := list_typ ();

Which two executable sections will display the message TRUE? (Choose two.)

BEGIN IF l_list.LIMIT IS NOT NULL THEN DBMS_OUTPUT.PUT_LINE (‘TRUE’); END IF; END;
BEGIN l_list.EXTEND; IF l_list.PRIOR (1_list.FIRST) IS NULL THEN DBMS_OUTPUT.PUT_LINE (‘TRUE’); END IF; END;
BEGIN l_list.EXTEND; IF l_list IS EMPTY THEN DBMS_OUTPUT.PUT_LINE (‘TRUE’); END IF; END
BEGIN IF l_list.FIRST IS NULL THEN DBMS_OUTPUT.PUT_LINE (‘TRUE’); END IF; END;
BEGIN IF l_list.FIRST =1 THEN DBMS_OUTPUT.PUT_LINE (‘TRUE’); END IF; END;

Go to Question:

Prev Question

Next Question