A、Deleting the records of employees who do not earn commission. B、Increasing the commission of employee 3 by the average commission earned in department 20. C、Finding the number of employees who do NOT earn commission and are working for department 20. D、Inserting into the table a new employee 10 who works for department 20 and earns a commission that is equal to the commission earned by employee 3. E、Creating a table called COMMISSION that has the same structure and data as the columns EMP_ID and COMMISSIONS of the EMP table. F、Decreasing the commission by 150 for the employees who are working in department 30 and earning a commission of more then 800.

点击查看答案

第7题

[单选题] Can you tell me how much a radio like this costs?（）

A、I‘d like to buy it. B、It‘s of very good quality. C、About eighty-five dollars. D、It depends on how you like it

点击查看答案

第8题

[] Click the Exhibit button and examine the data from the EMP table. The COMMISSION column shows the monthly commission earned by the employee. Which three tasks would require subqueries or joins in order to be performed in a single step?（） Click the Exhibit button and examine the data from the EMP table. The COMMISSION column shows the monthly commission earned by the employee. Which three tasks would require subqueries or joins in order to be performed in a single step?（）

A、A.deleting the records of employees who do not earn commission B、B.increasing the commission of employee 3 by the average commission earned in department 20 C、C.finding the number of employees who do NOT earn commission and are working for department 20 D、D.inserting into the table a new employee 10 who works for department 20 and earns a commission that is equal to the commission earned by employee 3 E、E.creating a table called COMMISSION that has the same structure and data as the columns EMP_ID and COMMISSION of the EMP table F、F.decreasing the commission by 150 for the employees who are working in department 30 and earning a commission of more than 800

点击查看答案

第9题

[多选题] Exhibit The COMMISSION column shows the monthly commission earned by the employee. Which two tasks would require subqueries or joins in order to be performed in a single step? （）

A、listing the employees who earn the same amount of commission as employee 3 B、finding the total commission earned by the employees in department 10 C、finding the number of employees who earn a commission that is higher than the average commission of the company D、listing the departments whose average commission is more that 600 E、listing the employees who do not earn commission and who are working for department 20 in descending order of the employee ID F、listing the employees whose annual commission is more than 6000

点击查看答案

账号：登录

答题记录

我的收藏

我的题库

客服

TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服