1. Home
  2. Discussions
  3. CIW
  4. CIW Web Development Series
  5. 1D0-541 Discussions
  6. 1D0-541 Exam Topic 4 Question 34 Discussion

CIW v5 Database Design Specialist 1D0-541 Question # 34 Topic 4 Discussion

 CIW Discussions      Browse All Questions      Go to Exam Detail      Get Premium Access
 Previous
Next  

CIW v5 Database Design Specialist 1D0-541 Question # 34 Topic 4 Discussion

1D0-541 Exam Topic 4 Question 34 Discussion:
Question #: 34
Topic #: 4

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';

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;

Get Premium 1D0-541 Questions
Actual exam question for CIW 1D0-541 exam by Thorne79691 at Aug 2, 2025, 12:00:00 AM

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.

Submit
 Previous
Next