Solved

The Database Manager Wants to Give Rubio and Doe the Ability

Question 74

Multiple Choice

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? 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


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

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions