PrepAway - Latest Free Exam Questions & Answers

Which group of SQL statements will perform this task?

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?

PrepAway - Latest Free Exam Questions & Answers

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;


Leave a Reply