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:

Supplemental Oxygen

Additional oxygen provided to patients to ensure they receive adequate oxygen levels in their blood, commonly used in conditions of respiratory distress or chronic lung conditions.

Suctioning

The process of removing obstructions, like fluids, from the body or a body part using a vacuuming action.

Bacterial Endocarditis

An infection of the inner lining of the heart's valves or chambers, typically caused by bacteria.

Prophylactic Antibiotics

Antibiotics given as a preventative measure against infection, rather than to treat an existing infection.