nerdexam
Oracle

1Z0-083 · Question #26

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

The correct answer is B. Schema Only accounts can be granted administrator privileges. D. Privilege Analysis is included in Oracle Enterprise Edition and no longer requires Database Vault. F. Unified Auditing can be configured to audit only events that are issued directly by an audited user. You can grant administrative privileges, such as SYSOPER and SYSBACKUP, to schema-only (passwordless) accounts. (B correct) - Privilege analysis is now available as part of Oracle Database Enterprise Edition. (D correct) - The unified auditing top-level statements feature…

Manage Database Security

Question

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

Options

  • AIf the password file location changes, then the new location is used automatically by the Oracle
  • BSchema Only accounts can be granted administrator privileges.
  • CAll the Oracle-supplied accounts are Schema Only accounts.
  • DPrivilege Analysis is included in Oracle Enterprise Edition and no longer requires Database Vault.
  • EUnified Auditing can be configured to audit only events that are issued indirectly by an audited
  • FUnified Auditing can be configured to audit only events that are issued directly by an audited user.

How the community answered

(37 responses)
  • A
    16% (6)
  • B
    73% (27)
  • C
    8% (3)
  • E
    3% (1)

Explanation

You can grant administrative privileges, such as SYSOPER and SYSBACKUP, to schema-only (passwordless) accounts. (B correct) - Privilege analysis is now available as part of Oracle Database Enterprise Edition. (D correct) - The unified auditing top-level statements feature enables you to audit top-level user (direct user) activities in the database without collecting indirect user activity audit data. (F correct) https://docs.oracle.com/en/database/oracle/oracle-database/19/newft/new-features.html

Topics

#Schema Only accounts#Unified Auditing#Privilege Analysis#Oracle 19c security

Community Discussion

No community discussion yet for this question.

Full 1Z0-083 Practice