Question 1 of 30
A database administrator is tasked with updating the salary of all employees in the \"Sales\" department by 10%. The current salary of employees is stored in a table called \"Employees\" with the following structure: `EmployeeID`, `Name`, `Department`, and `Salary`. The administrator executes the following SQL statement:
sql
ATE Employees
Salary = Salary * 1.10
RE Department = 'Sales';

Preparing for Microsoft 98-364 Database Fundamentals? Now land the interview.

73% of qualified candidates get rejected because of weak resumes. Build an ATS-optimized, recruiter-ready resume in under 5 minutes - free to start.

Build My Resume Free