试题详情
- 单项选择题 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;
关注下方微信公众号，在线模考后查看
热门试题
- Which data dictionar
- You created a view
- Which two tasks can
- Which are /SQL*Plus
- Which SQL statement
- Examine the descrip
- ClicktheExhibitbutto
- For which two action
- ExaminetheSQLstateme
- Which substitution v
- Which three statemen
- Which two statements
- Which two are true a
- Examinethestructureo
- In which two cases w
- Which SQL statement
- Evaluate this SQL s
- ExaminethedataintheE
- You need to change t
- Evaluate this SQL s