ocp-047-236 58

最新推荐文章于 2021-08-11 21:49:23 发布

转载最新推荐文章于 2021-08-11 21:49:23 发布 · 1.1k 阅读

ocp考试专栏收录该内容

61 篇文章

订阅专栏

本文讨论了一种在特定条件下高效地向BONUSES表中插入数据并更新员工工资的方法。人力资源经理决定给予符合条件的员工奖金及薪资调整。通过ORDERS表筛选出有销售业绩的员工，并结合EMPLOYEES表中的薪资信息，确定奖金发放标准。文章分析了不同SQL操作的特点，最终指出MERGE语句是最合适的选择。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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功能