The Following Three SQL Statements Are Executed One After the Other

question 35

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'

---

Definitions:

Labor Underutilization

A situation where a workforce does not utilize its full potential, often reflected in high unemployment, underemployment, and discouraged workers.

Marginally Attached Workers

Individuals who are not in the labor force, desire and are available for work, and have looked for a job sometime in the past 12 months but not in the four weeks preceding the survey.

Part-Time Employed

Individuals who are employed in work situations where the number of hours worked is less than the standard full-time hours.

Labor Underutilization

A situation where the workforce is not being used to its fullest potential, including phenomena such as underemployment and unemployment.