OCP 1Z0 051 QUESTION NO: 53

QUESTION NO: 53 
 
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 the same result 
B. Both the statements execute and give different results 
C. Only the second SQL statement executes successfully 
D. Only the first SQL statement executes successfully 
 
Answer: B

与正式题库95重复

http://blog.csdn.net/jgmydsai/article/details/26685417