The Following Three SQL Statements Are Executed One After the Other

question 60

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 and SQL#2,a member of the user group Personnel2 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

---

Definitions:

Utility Possibilities Frontier

A graphical representation showing all the possible combinations of two goods that two countries (or agents) can efficiently produce using all of their resources.

Marginal Rates

The amount of change in a variable (often related to costs or taxes) associated with a one-unit change in another variable.

Utility Functions

Mathematical representations describing the level of satisfaction or utility that a consumer derives from consuming a good or combination of goods.

Equilibrium

A state of balance in a market, where demand equals supply, and economic forces are at rest.