Which two are true?

Examine the statement:
GRANT select, insert, update
ON student_grades
TO manager
WITH GRANT OPTION;
Which two are true? (Choose two.)

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



Leave a Reply 0

Your email address will not be published. Required fields are marked *