The database manager wants to give Rubio and Doe the ability to modify the Project Relation shown in the exhibit. A temporary employee named Temp needs to access the data in the database to generate reports. Which group of SQL statements will perform this task?
A) GRANT UPDATE ON Project TO Rubio, Doe; GRANT SELECT ON Project TO Temp;
B) GRANT ALL PRIVILEGES ON Project TO Rubio, Doe; GRANT UPDATE ON Project TO Temp;
C) GRANT SELECT ON Project WHERE Manager = 'Rubio'; WHERE Manager = 'Doe';
D) GRANT UPDATE ON Project

Question

The database manager wants to give Rubio and Doe the ability to modify the Project Relation shown in the exhibit. A temporary employee named Temp needs to access the data in the database to generate reports. Which group of SQL statements will perform this task? 
A) GRANT UPDATE ON Project TO Rubio, Doe; GRANT SELECT ON Project TO Temp; 
B) GRANT ALL PRIVILEGES ON Project TO Rubio, Doe; GRANT UPDATE ON Project TO Temp; 
C) GRANT SELECT ON Project WHERE Manager = 'Rubio'; WHERE Manager = 'Doe'; 
D) GRANT UPDATE ON Project

Quizplus · Accepted Answer

The Answer of The database manager wants to give Rubio and Doe the ability to modify the Project Relation shown in the exhibit. A temporary employee named Temp needs to access the data in the database to generate reports. Which group of SQL statements will perform this task? 
A) GRANT UPDATE ON Project TO Rubio, Doe; GRANT SELECT ON Project TO Temp; 
B) GRANT ALL PRIVILEGES ON Project TO Rubio, Doe; GRANT UPDATE ON Project TO Temp; 
C) GRANT SELECT ON Project WHERE Manager = 'Rubio'; WHERE Manager = 'Doe'; 
D) GRANT UPDATE ON Project

The Database Manager Wants to Give Rubio and Doe the Ability