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
Q30: Inconsistency of customer names across operational databases
Q31: After execution of the commands SQL#1,SQL#2,and SQL#3,a
Q32: Which of the following descriptions will usually
Q33: Data administrators may specialize in:
A) database planning
B)
Q34: The following level of management deals with
Q36: In a DBMS environment,processing can be distributed
Q37: Object databases arose from the need to
Q38: Which of the following needs not be
Q39: In distributed database environments,the word "distributed" refers
Q40: Strategic management would be mostly interested in
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents