ocp 11g¿¼Ìâ´óÈ«£º1Z0-051-097Ì⣬ÍêÕûÌâ¿âÇëµã»÷ÕâÀïÁªÏµÀÏʦ×ÉѯÁ˽â

97. View the Exhibit and evaluate the structure and data in the CUST_STATUS table.

You issue the following SQL statement:

SQL> SELECT custno, NVL2(NULLIF(amt_spent, credit_limit), 0, 1000)"BONUS"

FROM cust_status;

Which statement is true regarding the execution of the above query?

A. It produces an error because the AMT_SPENT column contains a null value.

B. It displays a bonus of 1000 for all customers whose AMT_SPENT is less than CREDIT_LIMIT.

C. It displays a bonus of 1000 for all customers whose AMT_SPENT equals CREDIT_LIMIT, or

AMT_SPENT is null .

D. It produces an error because the TO_NUMBER function must be used to convert the result of the

NULLIF function before it can be used by the NVL2 function.

Answer: C