Oracle
1Z0-007 · Question #143
1Z0-007 Question #143: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-007 to reveal the answer and full explanation for question #143. The question stem and answer options stay visible for context.
Question
The EMPLOYEE tables have these columns: You want to display the name and annual salary multiplied by the commission_pct for all employees. For records that have a NULL commission_pct, a zero must be displayed against the calculated column. Which SQL statement displays the desired results?
Options
- ASELECT last_name, (salary * 12) * commission_pct FROM EMPLOYEES;
- BSELECT last_name, (salary * 12) * IFNULL(commission_pct, 0) FROM EMPLOYEES;
- CSELECT last_name, (salary * 12) * NVL2(commission_pct, 0) FROM EMPLOYEES;
- DSELECT last_name, (salary * 12) * NVL(commission_pct, 0) FROM EMPLOYEES;
Unlock 1Z0-007 to see the answer
You've previewed enough free 1Z0-007 questions. Unlock 1Z0-007 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.