移动端

  • 题王微信公众号

    题王微信公众号

    微信搜“题王网”真题密题、最新资讯、考试攻略、轻松拿下考试

单选题

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? ()

发布日期:2020-04-10

Management has asked you to calculate the value 12...
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;

题王网让考试变得更简单

扫码关注题王,更多免费功能准备上线!

此试题出现在

CMS专题

CMS专题

去刷题
热门试题热门资讯 相关试题

暂无相关推荐~