Which two are true in Oracle 19c and later releases?

Question

Options

• ASchema Only accounts can be granted administrator privileges.
• BIf the password file location changes, then the instance must be restarted.
• CUnified Auditing can be configured to audit only events that are issued directly by an audited
• DAll the Oracle-supplied accounts are Schema Only accounts.
• EUnified Auditing can be configured to audit only events that are issued indirectly by all users

• A
  76% (44)
• B
  16% (9)
• D
  2% (1)
• E
  7% (4)

Explanation

A is correct because Schema Only accounts - accounts with no password that cannot be directly logged into - can still be granted administrative privileges (e.g., SYSDBA, SYSOPER) in Oracle 19c. Their restriction is on direct authentication, not on privilege assignment.

C is correct because Unified Auditing policies support a top-level-only audit condition, meaning you can configure a policy to capture only SQL issued directly by a user (top-level statements), excluding recursive or indirect calls made by stored procedures or triggers on that user's behalf.

B is wrong because Oracle 19c no longer requires an instance restart when the password file location changes - this was a limitation in older releases that was removed. D is wrong because not all Oracle-supplied accounts are Schema Only; SYS and SYSTEM, for example, remain standard login accounts. E is wrong because it flips the logic of C - configuring auditing to capture only indirectly issued events from all users is not a supported or practical unified auditing configuration; it contradicts the purpose of top-level-only auditing.

Memory tip: Think "Schema Only = No door (can't log in), but can still carry a badge (hold admin privs)" for A. For C, remember "Direct = Detected" - unified auditing can be scoped to catch only what a user personally typed, not what ran on their behalf.

No community discussion yet for this question.