Which of the following code fragments would not raise an error?
A) IF rec_order.state = 'VA' THEN
Lv_tax_num := rec_order.sub * .06;
ELSEIF rec_order.state = 'ME' THEN
Lv_tax_num := rec_order.sub * .05;
ELSE
Lv_tax_num := rec_order.sub * .04;
END IF;
B) IF rec_order.state = 'VA' THEN
Lv_tax_num := rec_order.sub * .06;
ELSE IF rec_order.state = 'ME' THEN
Lv_tax_num := rec_order.sub * .05;
ELSE
Lv_tax_num := rec_order.sub * .04;
END IF;
C) IF rec_order.state = 'VA' THEN
Lv_tax_num := rec_order.sub * .06;
ELSIF rec_order.state = 'ME' THEN
Lv_tax_num := rec_order.sub * .05;
ELSE
Lv_tax_num := rec_order.sub * .04;
END IF;
D) IF rec_order.state = 'VA' THEN
Lv_tax_num := rec_order.sub * .06;
ELS IF rec_order.state = 'ME' THEN
Lv_tax_num := rec_order.sub * .05;
ELSE
Lv_tax_num := rec_order.sub * .04;
END IF;
Correct Answer:
Verified
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
Q56: Which of the following code fragments would
Q57: Which of the following allow us to
Q59: If the EXIT WHEN clause is not
Q60: Which of the following clauses ensures that
Q61: The _ section of the PL/SQL block
Q62: Which of the following code fragments would
Q63: The code order NUMBER(2) := 6; is
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