Multiple Choice
Which of the following code fragments is correct?
A) FOR i IN 1..tbl.COUNT
Lv_tot_num := lv_tot_num + tbl_roast(i) ;
END LOOP;
B) FOR i IN 1..tbl.COUNT LOOP
Lv_tot_num := lv_tot_num + tbl_roast(i)
END LOOP
C) FOR i IN 1..tbl.COUNT LOOP
Lv_tot_num = lv_tot_num + tbl_roast(i) ;
END LOOP;
D) FOR i IN 1..tbl.COUNT LOOP
Lv_tot_num := lv_tot_num + tbl_roast(i) ;
END LOOP;
Correct Answer:

Verified
Correct Answer:
Verified
Q1: The _ uses the LOOP and END
Q4: The LOOP statement is a mechanism that
Q5: The <u>basic</u> loop uses the LOOP and
Q6: When an IF statement checks only one
Q7: The following loop iterates four times.<br>BEGIN<br>WHILE lv_cnt_num
Q8: The following code fragment is a correct
Q9: FOR i IN 1..tbl_roast.COUNT LOOP lv_tot_num :=
Q10: A(n) <u>scalar</u> variable can hold only a
Q11: Which of the following code fragments would
Q72: The BEGIN section of a PL/SQL block