Oracle Database SQL — Question 202

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

Answer options

• A. WITH GRANT OPTTON cannot be used when granting an object privilege to PUBLIC.
• B. WITH GRANT OPTION can be used when granting an object privilege to both users and roles.
• C. Revoking an object privilege that was granted with the WITH GRANT OPTION clause has a cascading effect. C. Adding a primary key constraint to an existing table in another schema requires a system privilege.
• D. Adding a foreign key constraint pointing to a table in another schema requires the REFERENCES object privilege.
• E. Revoking a system privilege that was granted with WITH ADMIN OPTION has a cascading effect.

Correct answer: C, D, E

Explanation

Option C is correct because revoking an object privilege granted with the WITH GRANT OPTION will affect all users who also received that privilege. Option D is accurate as the REFERENCES object privilege is needed to create a foreign key constraint in another schema. Option E is true since revoking a system privilege granted with WITH ADMIN OPTION also impacts all associated privileges granted to others.