免费试学 报名即可领取免费资料

成都市庆云南街69号红星国际3栋3楼

您现在的位置: IT培训 > OCP > OCP考试 > 正文

OCP 1Z0-047 考试题库解析(8)

发布时间:2018-08-09 17:27:51

  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?

  A. Change the SELECT clause to SELECT last_name, department_id, salary*12+50 "Annual Compensation".

  B. Change the SELECT clause to SELECT last_name, department_id, salary+(50*12) "Annual Compensation".

  C. Change the SELECT clause to SELECT last_name, department_id, (salary+50)*12 "Annual Compensation".

  D. Change the SELECT clause to SELECT last_name, department_id, (salary*12)+50 "Annual Compensation".

  答案: C

  分析: 本题要求为每个工作满5年的员工的月工资增加$50,返回他们的LAST_NAME、DEPARTMENT_ID和年薪,年薪=(salary+50)*12。

 

免费试学

在下方预约即可免费领取视频学习资料