Oracle Database SQL 12c 1z0-071 Exam Practice Test 3

Question : 10 of 50

Marks: +1, -0

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?

Both the statements execute and give different results
Only the second SQL statement executes successfully
Both the statements execute and give the same result
Only the first SQL statement executes successfully

Validate

Go to Question:

Prev Question

Next Question