Which two blocks of code execute successfully?
A. DECLARE
TYPE tab_type IS TABLE OF NUMBER; my_tab tab_type; BEGIN my_tab (1) :=1;
END;
B. DECLARE
TYPE tab_type IS TABLE OF NUMBER; my_tab tab_type := tab_type(2);
BEGIN my_tab(1) :=55; END;
C. DECLARE
TYPE tab_type IS TABLE OF NUMBER; my_tab tab_type; BEGIN my_tab. EXTEND (2); my_tab (1) := 55;
END;
D. DECLARE
TYPE tab_type IS TABLE OF NUMBER; my_tab tab_type; BEGIN my_tab := tab_type (); my_tab (1) := 55;
END;
E. DECLARE
TYPE tab_type IS TABLE OF NUMBER my_tab tab_type := tab_type (2, NULL, 50);
BEGIN my_tab.EXTEND (3, 2); END;
|
Download Printable PDF. VALID exam to help you PASS. |
 |
BE
BE
set serveroutput on
DECLARE
TYPE tab_type IS TABLE OF NUMBER; my_tab tab_type;
BEGIN
my_tab (1) :=1;
END;
/
DECLARE
TYPE tab_type IS TABLE OF NUMBER; my_tab tab_type := tab_type(2);
BEGIN
my_tab(1) :=55;
END;
/
DECLARE
TYPE tab_type IS TABLE OF NUMBER; my_tab tab_type;
BEGIN
my_tab. EXTEND (2); my_tab (1) := 55;
END;
/
DECLARE
TYPE tab_type IS TABLE OF NUMBER; my_tab tab_type;
BEGIN
my_tab := tab_type (); my_tab (1) := 55;
END;
/
DECLARE
TYPE tab_type IS TABLE OF NUMBER;
my_tab tab_type := tab_type (2, NULL, 50);
BEGIN
my_tab.EXTEND (3, 2);
END;
/
Correct are B and E.