Oracle
1Z0-061 · Question #230
1Z0-061 Question #230: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-061 to reveal the answer and full explanation for question #230. 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-061 to see the answer
You've previewed enough free 1Z0-061 questions. Unlock 1Z0-061 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.