ocp-047-236 58
来源:互联网 发布:python google翻译 编辑:程序博客网 时间:2024/04/28 19:07
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功能
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功能
- ocp-047-236 58
- ocp-236
- ocp-58
- ocp 认证 047
- OCP-047external table
- OCP-047 Pivoting INSERT
- OCP-047 MERGE into
- OCP-047 REGEXP_INSTR()
- OCP-047 delete
- OCP-047 time_zone 参数
- OCP-047 CHECK
- ocp-047-13
- ocp-047-15
- ocp-047-17
- ocp-047-24
- ocp-047-23
- ocp-047-45
- ocp-047-64
- java bitset
- 笨鸟晚飞,算不算太晚?
- ubuntu12.04安装Chrome
- ojooo国外网赚项目每日收5美金挺不错 可以玩玩
- 升级到Dynamics CRM 2013需要注意的几个地方
- ocp-047-236 58
- 添加PLSQL 外网连接数据库
- delphi Move操作
- xe4 GridEh
- #define用法详解
- eclipse清空无效的workspace路径
- oracle11g卸载
- 编写断点续传和多线程下载模块
- Qt之QTextCodec乱谈