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:
A:
Role can be grant to user
C:
Create table privilege is not granted
D:
Execute privilege is not granted
F:
Delete privilege is not granted
Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 13-15