问题

Examine the data from the EMP table:The COMMISSION column shows the monthly commission ear

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 perform in a single step？（）

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.

参考答案

您可能感兴趣的试题

You may examine whether air is leaking from the t

答案解析
Examine the data in the EMPLOYEES table:Which three subqueries work? ()

答案解析
Click the Exhibit button and examine the data from the EMP table.The COMMISSION column sho

答案解析
Examine the data from the EMP table:EMP_ID DEPT_ID COMMISSION1 10 5002 20 10003 104 10 600

答案解析
Examine the following commands and their output:SQL> SELECT ename sal FROM emp WHERE e

答案解析
Examine the data in the EMPLOYEES and EMP_HIST tables:The EMP_HIST table is updated at the

答案解析