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;
Answer: C
You might also like to view...
________ is a collection of non-physical assets owned by an individual or company that are the result of innovation and are legally protected from being copied or used by unauthorized partners
A) Brand valuation B) Brand architecture C) Brand personality D) Intellectual property E) Category property
______ describes routine altruistic acts that increase productivity and build trusting relationships in the workplace.
Fill in the blank(s) with the appropriate word(s).
You should expect negative publicity from your message
A) when a connector dislikes you. B) if you have not purchased advertising space or time from a particular connector. C) when you do not share the same party affiliation as the connector. D) if you rely too heavily on traditional media to disseminate your message. E) if you are a large, multinational firm.
When compiling objects that call packaged program units, which of the following statements is true?
A. Restriction violations are not discovered until runtime. B. Only the program body is used for verification. C. Because only the package body information is used, the PL/SQL compiler cannot determine if the restrictions on functions within SQL statements are being respected. D. Restriction violations are discovered at compile time.