Which of the following code fragments would not raise an error?
A) BEGIN
LOOP
DBMS_OUTPUT.PUT_LINE( lv_cnt_num ) ;
Lv_cnt_num := lv_cnt_num + 1;
END LOOP;
END;
B) BEGIN
LOOP
DBMS_OUTPUT.PUT_LINE( lv_cnt_num ) ;
EXIT WHEN lv_cnt_num >= 5;
Lv_cnt_num := lv_cnt_num + 1;
END;
C) BEGIN
LOOP
DBMS_OUTPUT.PUT_LINE( lv_cnt_num ) ;
EXIT WHEN lv_cnt_num >= 5;
Lv_cnt_num := lv_cnt_num + 1
END LOOP
END
D) BEGIN
LOOP
DBMS_OUTPUT.PUT_LINE( lv_cnt_num ) ;
EXIT WHEN lv_cnt_num >= 5;
Lv_cnt_num := lv_cnt_num + 1;
END LOOP;
END;
Correct Answer:
Verified
Q51: Which of the following statements is True?
A)
Q52: Which of the following evaluates conditions and
Q53: BEGIN LOOP
DBMS_OUTPUT.PUT_LINE(lv_cnt_num);
Lv_cnt_num := lv_cnt_num + 1;
EXIT WHEN
Q54: Which of the following code fragments would
Q55: Which of the following code fragments would
Q57: Which of the following allow us to
Q58: Which of the following code fragments would
Q59: If the EXIT WHEN clause is not
Q60: Which of the following clauses ensures that
Q61: The _ section of the PL/SQL block
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents