Prev 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?

Use SQL*Loader utility.

Use the MERGE statement.

Use a multitable insert operation.

Use a correlated UPDATE statement.

Prev Question
Next Question

Leave a Reply

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