Multiple Choice
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
Correct Answer:
Verified
Q56: The only required sections of a PL/SQL
Q57: Which of the following does not use
Q58: The code order NUMBER(2) := 6; is
Q59: The statements that are used to control
Q60: The following code fragment is a correct
Q62: The EXIT WHEN clause ensures that a
Q63: Which of the following statements is correct?<br>A)
Q64: If the <u>WHERE </u>clause is not included
Q65: Which of the following code fragments would
Q66: The syntax of the following code fragment