You work as a database administrator at ABC.com. You study the exhibit carefully. Exhibit:
You issue the following SQL statement: Which statement is true regarding the execution of
the above query?
A.
It displays a bonus of 1000 for all customers whose AMT_SPENT is less than
CREDIT_LIMIT.
B.
It displays a bonus of 1000 for all customers whose AMT_SPENT equals
CREDIT_LIMIT, or AMT_SPENT is null.
C.
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.
D.
It produces an error because the AMT_SPENT column contains a null value.