Oracle
1Z0-071 · Question #211
1Z0-071 Question #211: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-071 to reveal the answer and full explanation for question #211. The question stem and answer options stay visible for context.
Question
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?
Options
- ABoth the statements execute and give different results
- BOnly the second SQL statement executes successfully
- CBoth the statements execute and give the same result
- DOnly the first SQL statement executes successfully
Unlock 1Z0-071 to see the answer
You've previewed enough free 1Z0-071 questions. Unlock 1Z0-071 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.