The PRODUCTS table has the following structure.
Evaluate the following two SQL statements:
SQL>SELECT prod_id, NVL2 (prod_expiry_date, prod_expiry_date + 15, ‘ ‘) FROM products; SQL>SELECT prod_id, NVL (prod_expiry_date, prod_expiry_date + 15) FROM products;
Which statement is true regarding the outcome?
A. Both the statements execute and give different results
B. Only the second SQL statement executes successfully
C. Both the statements execute and give the same result
D. Only the first SQL statement executes successfully
|
Download Printable PDF. VALID exam to help you PASS. |
 |
A
If prod_expire_date is NOT NULL then first query returns prod_expiry_date + 15 but second query returns prod_expiry_date