CIW Exam 1D0-541 Topic 1 Question 25 Discussion

Actual exam question for CIW's 1D0-541 exam

Question #: 25
Topic #: 1

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?

AGRANT UPDATE ON Project TO Rubio, Doe;
GRANT SELECT ON Project TO Temp;

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

CGRANT SELECT ON Project
WHERE Manager = 'Rubio';
GRANT SELECT ON Project
WHERE Manager = 'Doe';

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

Show Suggested Answer

Suggested Answer: A

by Shawna at May 09, 2022, 09:23 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!