试题详情
- 单项选择题 The EMPLOYEE tables has 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?（） A、SELECT last_name, (salary * 12) * commission_pct FROM EMPLOYEES;
B、SELECT last_name, (salary * 12) * IFNULL(commission_pct, 0) FROM EMPLOYEES;
C、SELECT last_name, (salary * 12) * NVL2(commission_pct, 0) FROM EMPLOYEES;
D、SELECT last_name, (salary * 12) * NVL(commission_pct, 0) FROM EMPLOYEES;
关注下方微信公众号，在线模考后查看
热门试题
- Which three SELECT s
- The STUDENT_GRADES
- The user Alice wants
- You need to design
- Which is an iSQL*Plu
- You need to create
- Which describes the
- Which statement expl
- Which SQL statement
- Examinethestructureo
- You need to perform
- Mary has a view call
- Examine this stateme
- Managementhasaskedyo
- Which SQL statement
- The EMP table conta
- Evaluate this SQL s
- You need to display
- TheCUSTOMERStablehas
- Which two statements