Oracle
1Z0-061 · Question #296
1Z0-061 Question #296: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-061 to reveal the answer and full explanation for question #296. The question stem and answer options stay visible for context.
Question
Examine the data in the LIST_PRICE and MIN_PRICE columns of the PRODUCTS table: Which two expressions give the same output? (Choose two.)
Options
- ANVL(NULLIF(list_price, min_price), 0)
- BNVL(COALESCE(list_price, min_price), 0)
- CNVL2(COALESCE(list_price, min_price), min_price, 0)
- DCOALESCE(NVL2(list_price, list_price, min_price), 0)
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.