Home » Oracle » 1z0-061 » 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”?
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;
Correct Answer: B
Explanation/Reference:
Explanation:
to achieve the result you must add 100 to sal before multiply with 12.
Select ename, sal, 12*(sal+100) from EMP;
Incorrect answer:
A. Multiplication and division has priority over addition and subtraction in Operator precedence.
C. Give wrong results
D. Wrong syntax
Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 1-11
Download Printable PDF. VALID exam to help you PASS.
|
|