CIW
1D0-541 · Question #87
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…
The correct answer is A. GRANT UPDATE ON Project TO Rubio, Doe. See the full explanation below for the reasoning.
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?
Exhibit
Options
- AGRANT UPDATE ON Project TO Rubio, Doe;
- BGRANT ALL PRIVILEGES ON Project TO Rubio, Doe;
- CGRANT SELECT ON Project
- DGRANT UPDATE ON Project
How the community answered
(23 responses)- A74% (17)
- B13% (3)
- C4% (1)
- D9% (2)
Community Discussion
No community discussion yet for this question.