试题详情
- 单项选择题 Management has asked you to calculate the value 12*salary* commission_pct for all the employees in the EMP table. The EMP table contains these columns:
Which statement ensures that a value is displayed in the calculated columns for all employees?（） A、SELECT last_name, 12*salary* commission_pct FROM emp;
B、SELECT last_name, 12*salary* (commission_pct,0) FROM emp;
C、SELECT last_name, 12*salary*(nvl(commission_pct,0)) FROM emp;
D、SELECT last_name, 12*salary*(decode(commission_pct,0)) FROM emp;
关注下方微信公众号，在线模考后查看
热门试题
- Examine the structu
- Evaluate the SQL sta
- Examinethestructurei
- Examine the descrip
- Scott issues the SQ
- Examine the descrip
- Which two statements
- ClicktheExhibitbutto
- Examine the structu
- The EMP table has t
- Which two statements
- TheCUSTOMERStablehas
- Which clause would y
- Which statement desc
- What is true regardi
- Which two tasks can
- Which three are true
- You need to create a
- Which iSQL*Plus feat
- The EMP table conta