多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

Evaluate this SQL statement: SELECT ename, sal, 12*sal+100 FROM emp; The SAL column stores the monthly salary of the employee. Which change must be made to the above syntax to calculate the annual compensation as "monthly salary plus a monthly bonus of $100, multiplied by 12"?()

  • A、No change is required to achieve the desired results.
  • B、SELECT ename, sal, 12*(sal+100) FROM emp;
  • C、SELECT ename, sal, (12*sal)+100 FROM emp;
  • D、SELECT ename, sal+100,*12 FROM emp;
正确答案:B
答案解析:
进入题库查看解析

微信扫一扫手机做题