Examine the statement:
GRANT select, insert, update
ON student_grades
TO manager
WITH GRANT OPTION;
Which two are true? (Choose two.)
A.
MANAGER must be a role.
B.
It allows the MANAGER to pass the specified privileges on to other users.
C.
It allows the MANAGER to create tables that refer to the STUDENT_GRADES table.
D.
It allows the MANAGER to apply all DML statements on the STUDENT_GRADES table.
E.
It allows the MANAGER the ability to select from, insert into, and update the
STUDENT_GRADES table.
F.
It allows the MANAGER the ability to select from, delete from, and update the
STUDENT_GRADES table.
Explanation:
GRANT ROLE to ROLE/USER
Incorrect answer:
ARole can be grant to user
CCreate table privilege is not granted
DExecute privilege is not granted
FDelete privilege is not granted
Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 13-15
The explanations are wrong.
A – Manager can be either a role or a user
C – The privilege missing is REFERENCES not create table
D – You can’t grant execute on a table! DELETE is not granted so you can’t apply all DML statements to the table
F – the only right explanation.