Oracle
1Z0-007 · Question #19
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…
Sign in or unlock 1Z0-007 to reveal the answer and full explanation for question #19. The question stem and answer options stay visible for context.
Displaying Data from Multiple Tables and Subqueries
Question
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? (Choose three)
Options
- ADeleting the records of employees who do not earn commission.
- BIncreasing the commission of employee 3 by the average commission earned in department 20.
- CFinding the number of employees who do NOT earn commission and are working for department 20.
- DInserting into the table a new employee 10 who works for department 20 and earns a commission that
- ECreating a table called COMMISSION that has the same structure and data as the columns EMP_ID
- FDecreasing the commission by 150 for the employees who are working in department 30 and earning
Unlock 1Z0-007 to see the answer
You've previewed enough free 1Z0-007 questions. Unlock 1Z0-007 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#subqueries in DML#joins#aggregate in UPDATE#CREATE TABLE AS SELECT