CIW 1D0-541 Exam - Topic 1 Question 25 Discussion

Question

CIW 1D0-541 Exam - Topic 1 Question 25 Discussion

The database manager wants to give Rubio and Doe the ability to modify the Project Relationshown in the exhibit. A temporary employee named Temp needs to access the data in the databaseto generate reports. Which group of SQL statements will perform this task?

B) GRANT ALL PRIVILEGES ON Project TO Rubio, Doe; GRANT UPDATE ON Project TO Temp;

C) GRANT SELECT ON Project WHERE Manager = 'Rubio'; GRANT SELECT ON Project WHERE Manager = 'Doe';

D) GRANT UPDATE ON Project WHERE Manager = 'Rubio'; GRANT UPDATE ON Project WHERE Manager = 'Doe'; GRANT SELECT ON Project TO Temp;

Accepted Answer

A) GRANT UPDATE ON Project TO Rubio, Doe; GRANT SELECT ON Project TO Temp;

CIW 1D0-541 Exam - Topic 1 Question 25 Discussion

CIW 1D0-541 Exam - Topic 1 Question 25 Discussion

Contribute your Thoughts:

Nikita

Jamika

Cory

Maira

Skye

Rozella

Ilene