Oracle Database SQL — Question 198

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

Answer options

• A. System privileges always set privileges for an entire database.
• B. PUBLIC can be revoked from a user.
• C. All roles are owned by the SYS schema.
• D. A user has all object privileges for every object in their schema by default.
• E. A role is owned by the user who created it.
• F. A role can contain a combination of several privileges and roles.
• G. PUBLIC acts as a default role granted to every user in a database.

Correct answer: D, F, G

Explanation

The correct answer includes D, F, and G because a user indeed has all object privileges for objects in their schema by default (D), a role can include a mix of privileges and other roles (F), and PUBLIC is a default role granted to all users (G). Options A, B, C, and E are incorrect as they misrepresent the nature of system privileges, the revocability of PUBLIC, the ownership of roles, and the ownership of roles respectively.