试题详情
- 多项选择题 Examine the data from the EMP table: EMP_ID DEPT_ID COMMISSION 1 10 500 2 20 1000 3 10 4 10 600 5 30 800 6 30 200 7 10 8 20 300 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.
关注下方微信公众号，在线模考后查看
热门试题
- What does the TRUNCA
- Examine the structu
- Evaluate the SQL st
- Examine the structu
- Which is an /SQL*Plu
- Managementhasaskedyo
- Which two statements
- The EMPLOYEE tables
- Which SQL statement
- Which four statement
- EvaluatetheSQLstatem
- Which is a valid CRE
- Exhibit Examinethed
- Examine the structu
- Which three are true
- Examine this statem
- What is true of usin
- Examine the descrip
- Which statement expl
- Which is an iSQL*Plu