​If It Is Possible for a Subquery to Return a NULL

question 45

Multiple Choice

​If it is possible for a subquery to return a NULL value to the outer query for comparison,the ____ function should be used to substitute an actual value for the NULL.

• A) ​IS NULL
• B) ​NVL
• C) ​!NVL
• D) ​NVLS

---

Definitions:

Forward Rate

The predetermined rate at which two parties will exchange currencies on a future date, agreeing upon it in the present.

Spot Rate

The present cost at which a specific asset like a commodity, currency, or security is available for purchase or sale with immediate delivery.

Net Present Value

A financial metric that calculates the value of a project or investment by discounting future cash flows back to their present value to assess profitability and risk.

Inflation Rate

The rate at which the general level of prices for goods and services is rising, and subsequently, purchasing power is falling, usually measured over a year.