问题

Evaluate this SQL statement:SELECT ename sal 12* sal+100 FROM emp;The SAL column stores

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 abovesyntax 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;

参考答案

您可能感兴趣的试题

【C11】A．appraiseB．estimateC．valueD．evaluate

答案解析
We can evaluate the alternatives for a solution b

答案解析
Examine this command:SQL > exec DBMS_STATS.SET_TABLE_PREFS (‘SH’ ‘CUSTOMERS’ ‘PUBLISH’ ‘false’);Which three statements are true about the effect of this command?()

答案解析
The user Sue issues this SQL statement:GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION

答案解析
Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement? ()

答案解析
Evaluate the SQL statement:What is the result of the statement?()

答案解析