Kizspy | Question: 37
(Choose 1 answer)
The following SQL updates the first employees(empID = 1) with a new empName and new City from employees table
A. UPDATE employees
SET empName = 'Alfred Schmidt' AND City= 'Frankfurt'
WHERE empID= 1;
B. UPDATE employees
SET empID=1
WHERE empName = 'Alfred Schmidt' AND City= 'Frankfurt';
C. UPDATE employees
SET empName = 'Alfred Schmidt', City= 'Frankfurt'
WHERE empID= 1;
D. UPDATE employees
SET empID=1
WHERE empName = 'Alfred Schmidt', City= 'Frankfurt';
Pleven tow.Jen
