Exam 1z0-071 All QuestionsBrowse all questions from this exam
Question 238

Which three are true about system and object privileges? (Choose three.)

    Correct Answer: B, C, D

    WITH GRANT OPTION can be used when granting an object privilege to both users and roles, making option B true. Revoking an object privilege granted with WITH GRANT OPTION does have a cascading effect, so option C is also true. Adding a foreign key constraint that points to a table in another schema requires the REFERENCES object privilege, which makes option D correct. Option A is incorrect because WITH GRANT OPTION can be specified when granting object privileges to users and roles, but not to PUBLIC. Option E is incorrect because revoking a system privilege granted with WITH ADMIN OPTION does not have a cascading effect.

Discussion
tom100menOptions: BCD

But A is also not correct "You can specify WITH GRANT OPTION only when granting to a user or to PUBLIC, not when granting to a role. "

ogi33Options: CD

CCD second C alter any table privs

tom100menOptions: ACD

ACD for me E is not correct http://www.dba-oracle.com/t_with_grant_admin_privileges.htm