Oracle
1Z0-007 · Question #69
1Z0-007 Question #69: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-007 to reveal the answer and full explanation for question #69. The question stem and answer options stay visible for context.
Question
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"?
Options
- ANo change is required to achieve the desired results.
- BSELECT ename, sal, 12*(sal+100) FROM emp;
- CSELECT ename, sal, (12*sal)+100 FROM emp;
- DSELECT ename, sal+100,*12 FROM emp;
Unlock 1Z0-007 to see the answer
You've previewed enough free 1Z0-007 questions. Unlock 1Z0-007 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.