ocp-047-236 58

58. Evaluate the following statement:


CREATE TABLE bonuses(
   employee_id NUMBER,
   bonus NUMBER DEFAULT 100
   );
 
The details of all employees who have made sales need to be inserted into the BONUSES table.
有销售的雇员的详细情况需要插入BONUSES表。


You can obtain the list of employees who have made sales based on the SALES_REP_ID column of the ORDERS table.
你可以用过ORDERS表的SALES_REP_ID列获得有销售的雇员的列表。


The human resources manager now decides that employees with a salary of $8,000 or less should receive a bonus.
人力资源经理现在决定有8000美元或以下工资的雇员将得到奖励


Those who have not made sales get a bonus of 1% of their salary.
那些没有销售的人获得他们工资1%的奖励


Those who have made sales get a bonus of 1% of their salary and also a salary increase of 1%.
那些有销售的人获得他们工资1%的奖励并且工资增加1%


The salary of each employee can be obtained from the EMPLOYEES table. 
每个雇员的工资可以在EMPLOYEES表获得。


本题要求向bonuses表插入雇员工资1%的记录，并修改雇员的工资为原来工资的101%
只有merge可以同时insert和update
insert语句可以有选择性的插入多条记录到多张表，但是没有办法去update记录。


Which option should be used to perform this task most efficiently? 
A. MERGE (right)


B. Unconditional INSERT
没有update功能


C. Conditional ALL INSERT 
没有update功能


D. Conditional FIRST INSERT 
没有update功能