1Z0-007 Question #19: Real Exam Question with Answer & Explanation

Question

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

Explanation

Increasing the commission of employee 3 by the average commission earned in department 20 will require sub-queries or joins in order to perform in a single step. 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 is correct answer also. To create a table that has the same structure as subset of columns from another table it's required to use a subquery in order to perform in a single step. Incorrect Answers A: This query can be done without using sub-queries or joins in order to perform in a single step. C: It is not required to use sub-queries or joins to create SQL statement for that query. F: This query can be done without using sub-queries or joins in order to perform in a single step: only two conditions in the WHERE clause should be specified.

No community discussion yet for this question.