Category: 1z0-042 (v.1)

Exam 1Z0-042: Database 10g: Administration I (updated June 13th, 2013)

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

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?


Page 1 of 1712345...10...Last »