试题详情
- 单项选择题 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: LAST NAME VARCNAR2(35) NOT NULL SALARY NUMBER(9,2) NOT NULL COMMISION_PCT NUMBER(4,2) 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;
关注下方微信公众号，在线模考后查看
热门试题
- Which two statements
- Examine the SQL sta
- Evaluate the set of
- In which scenario wo
- Which SELECT stateme
- The STUDENT_GRADES
- What is true regardi
- Which constraint can
- The CUSTOMERS table
- What is true about s
- Examine the structu
- Examinethedescriptio
- Examine the structu
- Examine the descrip
- Examine the SQL sta
- Which describes the
- You need to calculat
- Examine the structu
- A subquery can be us
- Which three statemen