Oracle
1Z0-061 · Question #151
1Z0-061 Question #151: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-061 to reveal the answer and full explanation for question #151. The question stem and answer options stay visible for context.
Question
Examine the structure of the INVOICE table: Which two SQL statements would execute successfully? (Choose two.)
Options
- ASELECT inv_no, NVL2(inv_date, 'Pending', 'Incomplete')
- BSELECT inv_no, NVL2(inv_amt, inv_date, 'Not Available')
- CSELECT inv_no, NVL2(inv_date, sysdate-inv_date, sysdate)
- DSELECT inv_no, NVL2(inv_amt, inv_amt*.25, 'Not Available')
Unlock 1Z0-061 to see the answer
You've previewed enough free 1Z0-061 questions. Unlock 1Z0-061 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.