Oracle Database Administration II — Question 177

Which three are true in Oracle 19c and later releases? (Choose three.)

Answer options

• A. If the password file location changes, then the new location is used automatically by the Oracle Server.
• B. Schema Only accounts can be granted administrator privileges.
• C. All the Oracle-supplied accounts are Schema Only accounts.
• D. Privilege Analysis is included in Oracle Enterprise Edition and no longer requires Database Vault.
• E. Unified Auditing can be configured to audit only events that are issued indirectly by an audited user.
• F. Unified Auditing can be configured to audit only events that are issued directly by an audited user.

Correct answer: B, D, F

Explanation

Option B is correct because Schema Only accounts can indeed be granted administrative privileges. Option D is also correct as Privilege Analysis is included in Oracle Enterprise Edition without needing Database Vault. Option F is accurate since Unified Auditing can be configured to audit direct actions, while options A, C, and E are incorrect interpretations of how these features work in Oracle 19c.