The Following Three SQL Statements Are Executed One After the Other

Multiple Choice

The following three SQL statements are executed one after the other.
SQL#1:
CREATE VIEW Payroll
SELECT EmpName, Salary, Status
FROM Employee
Where Job NOT IN ('Manager', 'Supervisor')
SQL#2:
GRANT SELECT, UPDATE ON Payroll
To Personnel1, Personnel2
SQL#3:
REVOKE UPDATE on Payroll From Personnel2


-After execution of the commands SQL#1,SQL#2,and SQL#3,a member of the user group Personnel2 may:

A) Access the Salary of an Employee whose job is 'Clerk'
B) Change the Salary of any Employee
C) Access the Salary of any Employee
D) Change the Salary of an Employee whose job is 'Clerk'