DECLARE TYPE tab_type IS TABLE OF NUMBER; my_tab tab_type; BEGIN my_tab (1) :=1; END;
-- Reference to uninitialized collection
DECLARE TYPE tab_type IS TABLE OF NUMBER; my_tab tab_type := tab_type(2);
BEGIN
dbms_output.put_line(my_tab(1)); --2
my_tab(1) :=55;
dbms_output.put_line(my_tab(1)); --55
END;
-- Executes successfully
DECLARE TYPE tab_type IS TABLE OF NUMBER; my_tab tab_type; BEGIN my_tab. EXTEND (2); my_tab (1) := 55; END;
-- Reference to uninitialized collection
DECLARE TYPE tab_type IS TABLE OF NUMBER; my_tab tab_type; BEGIN my_tab := tab_type(); my_tab (1) := 55; END;
-- Subscript beyond count
The ANs E missing ";" "end;". Anyhow i check it and seems that the correct answers are BC.
The answer E could be fine if it was :
"DECLARE TYPE tab_type IS TABLE OF NUMBER; my_tab tab_type := tab_type (2, NULL, 50); BEGIN my_tab.EXTEND (3, 2); END;"
and not
DECLARE TYPE tab_type IS TABLE OF NUMBER my_tab tab_type := tab_type (2, NULL, 50); BEGIN my_tab.EXTEND (3, 2);
This section is not available anymore. Please use the main Exam Page.1z0-148 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Tinamoran
Highly Voted 5 years, 5 months agoWrath
Highly Voted 5 years, 5 months agoRakeshpro
Most Recent 2 years, 7 months agoRakeshpro
2 years, 7 months agochrishillinger
2 years, 8 months agoCosminCof
4 years, 4 months agocertyk
4 years, 7 months agocertyk
4 years, 7 months agoszefco
4 years, 11 months ago