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
Correct Answer:

Verified
Correct Answer:
Verified
Q55: List the three components of the SQL:2003
Q56: The process of developing enterprise models of
Q57: Because benchmarks need to be specific to
Q58: Which of the following is primarily used
Q59: Data that describes the source,use,value,and meaning of
Q61: Inconsistency of customer names across operational databases
Q62: In the DBMS evaluation process,a useful decision
Q63: For remotely stored procedures and functions,when _
Q64: Since most DBMSs are very good at
Q65: Data administrators may specialize in:<br>A) database planning<br>B)