After execution of the commands SQL#1,SQL#2,and SQL#3,a member of the user group Personnel1 may:
A) Change the Salary of any Employee
B) Access the Salary of any Employee
C) Change the Salary of an Employee whose job is 'Clerk'
D) All of the above

Question

Quizplus · Accepted Answer

The user group Personnel1 has been granted the SELECT privilege on the Salary column of the Employee table, which allows them to access the Salary of any Employee. They have also been granted the UPDATE privilege on the Salary column, which allows them to change the Salary of any Employee. However, they have not been granted the UPDATE privilege on the Job column, which means they cannot change the Job of any Employee. Therefore, the correct answer is D: All of the above.

After Execution of the Commands SQL#1,SQL#2,and SQL#3,a Member of the User