Free 1D0-541 Web TestEngine Demo

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

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;

1D0-541 Web TestEngine demo