Multiple Choice
Why would the following code raise an error? 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;
A) Semicolon after THEN is omitted
B) No space between ELSE and IF
C) ELSEIF is not a keyword
D) ":=" should be "="
Correct Answer:

Verified
Correct Answer:
Verified
Q22: <u>Variables</u> are named memory areas that hold
Q23: What is the purpose of control structures?
Q24: The following loop terminates when the lv_cnt_num
Q25: BEGIN WHILE lv_cnt_num <= 5 LOOP<br>DBMS_OUTPUT.PUT_LINE(lv_cnt_num);<br>Lv_cnt_num :=
Q26: To declare a variable, you must supply
Q28: Which of the following clauses ensures that
Q29: The _ loop is constructed with conditions
Q30: When an IF statement checks only one
Q31: Even though the EXIT clause can be
Q32: With respect to processing efficiency, the less