What would you do to implement these changes in one step?

Previous Question
Next Question

The employee IDs of employees who have made sales in the company are transferred from the
EMPLOYEES table to the BONUS table with a default bonus value. Later, the human resources
department decides to give bonuses to employees as per the following conditions:
1. Employees with a salary of $8,000 or less should receive a bonus.
2. Employees who have not made sales get a bonus of 1% of their salary.
3. Employees who already made sales get an increase in their bonus equal to 1% of their salary.
What would you do to implement these changes in one step?

A.
Use SQL*Loader utility.

B.
Use the MERGE statement.

C.
Use a multitable insert operation.

D.
Use a correlated UPDATE statement.

Previous Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *