Oracle Exam 1Z0-148 Topic 2 Question 16 Discussion

Actual exam question for Oracle's 1Z0-148 exam

Question #: 16
Topic #: 2

Examine the code:

Which two blocks can be used to complete the executable section such that LIST2 is dense? (Choose two.)

AFOR idx IN list1.FIRST .. list1.LAST LOOP
IF list1.EXISTS(idx) THEN
list2(idx) := list1(idx);
END IF;
END LOOP;

BFOR idx IN list1.FIRST .. list1.LAST LOOP
list2(idx) := list1(idx);
END LOOP;

Cidx:= list1.FIRST;
WHILE (idx IS NOT NULL) LOOP
list2(list2.COUNT + 1) := list1(idx);
idx := list1.NEXT(idx);
END LOOP;

DFORALL idx IN list1.FIRST .. list1.LAST LOOP
list2(list2.COUNT + 1) := list1(idx);

Eidx:= list1.FIRST; LOOP
EXIT WHEN idx IS NULL;
list2(list2.COUNT + 1) := list1(idx);
idx := list1.NEXT(idx);
END LOOP;

Show Suggested Answer

Suggested Answer: C, D

by Terrilyn at May 05, 2022, 04:14 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!