Oracle Database SQL — Question 118

Which three are true about privileges? (Choose three.)

Answer options

• A. A combination of object and system privileges can be granted to a role.
• B. All types of schema objects have associated object privileges.
• C. Schema owners can grant object privileges on objects in their schema to any other user or role.
• D. Only users with the DBA role can create roles.
• E. Only users with the GRANT ANY PRIVILEGE privilege can grant and revoke system privileges from other users.
• F. Object privileges granted on a table automatically apply to all synonyms for that table.

Correct answer: A, C, F

Explanation

Option A is correct as both object and system privileges can indeed be combined and assigned to a role. Option C is accurate because schema owners have the authority to grant privileges on their objects to others. Option F is also correct since privileges on a table apply to its synonyms. Options B, D, and E are incorrect as they misrepresent the rules governing privileges and role creation.