Oracle
1Z0-047 · Question #206
1Z0-047 Question #206: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-047 to reveal the answer and full explanation for question #206. The question stem and answer options stay visible for context.
Question
View the Exhibit and examine the description of the EMPLOYEES table. Your company decided to give a monthly bonus of $50 to all the employees who have completed five years in the company. The following statement is written to display the LAST_NAME, DEPARTMENT_ID, and the total annual salary: SELECT last_name, department_id, salary+50*12 "Annual Compensation" FROM employees WHERE MONTHS_BETWEEN(SYSDATE, hire_date)/12 >= 5; When you execute the statement, the "Annual Compensation" is not computed correctly. What changes would you make to the query to calculate the annual compensation correctly?
Exhibit
Options
- AChange the SELECT clause to SELECT last_name, department_id, salary*12+50 "Annual Compensation".
- BChange the SELECT clause to SELECT last_name, department_id, salary+(50*12) "Annual Compensation".
- CChange the SELECT clause to SELECT last_name, department_id, (salary+50)*12 "Annual Compensation".
- DChange the SELECT clause to SELECT last_name, department_id, (salary*12)+50 "Annual Compensation".
Unlock 1Z0-047 to see the answer
You've previewed enough free 1Z0-047 questions. Unlock 1Z0-047 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.