Multiple Choice
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;
Which of the clauses in the code fragment above would not cause the IF statement to raise an error if it were excluded?
A) ELSE
B) IF
C) END IF
D) THEN
Correct Answer:

Verified
Correct Answer:
Verified
Q36: Which of the following initializes the variable
Q37: Which of the following lines of code
Q38: _ are used to change the values
Q39: The simple IF statement performs an action
Q40: The _ section of a PL/SQL block
Q42: The<u> basic</u> loop dictates exactly how many
Q43: To keep code efficient and minimize statement
Q44: <u>Loops</u> are used for situations in which
Q45: If the EXIT WHEN clause is not
Q46: The only required sections of a PL/SQL