Which Oracle Database component is audited by default if the unified Auditing option is enabled?

Which Oracle Database component is audited by default if the unified Auditing option is enabled?

Which Oracle Database component is audited by default if the unified Auditing option is enabled?

A.
Oracle Data Pump

B.
Oracle Recovery Manager (RMAN)

C.
Oracle Label Security

D.
Oracle Database Vault

E.
Oracle Real Application Security

Explanation:
Type of Unified auditing:
Standard
Fine Grained Audit
XS
Database Vault (not D)
Label Security (not C)
RMAN AUDIT (not B)
Data Pump (not A)
Note:
* Oracle 12c introduces Unified Auditing, which consolidates database audit records including :-DDL, DML, DCL
Fine Grained Auditing (DBMS_FGA)

Oracle Database Real Application Security
Oracle Recovery Manager
Oracle Database Vault
Oracle Label Security
Oracle Data Mining
Oracle Data Pump
Oracle SQL*Loader Direct Load



Leave a Reply 21

Your email address will not be published. Required fields are marked *


C

C

About Auditing Oracle Recovery Manager Events
Unlike other Oracle Database components, you do not create a unified audit policy for Oracle Recovery Manager events. The UNIFIED_AUDIT_TRAIL data dictionary view has a set of fields, whose names begin with RMAN_, that automatically record Recovery Manager-related events. However, you must have the AUDIT_ADMIN or AUDIT_VIEWER role in order to query the UNIFIED_AUDIT_TRAIL view to see these events. If you have the SYSBACKUP or the SYSDBA administrative privilege, then you can find additional information about Recovery Manager jobs by querying views such as V$RMAN_STATUS or V$RMAN_BACKUP_JOB_DETAILS.

tamil

tamil

Answer is B

praveen

praveen

As tamil said, it is B. For RMAN component we don’t need to create a policy. Ex: for Datapump export we create a policy as
Create audit policy policy1 actions component = datapump export
audit policy policy1;

But for RMAN, we don’t need to create a policy. For all other components , we need to create a policy.

Mohammad Rafiq

Mohammad Rafiq

B. Oracle Recovery Manager (RMAN)

VSMC

VSMC

B.
Oracle Recovery Manager (RMAN)

Nagaraj

Nagaraj

B. is the right answer

Umaruddin Ansari

Umaruddin Ansari

B is correct answer.

you don’t need to create policy for RMAN

shabbir ahmed

shabbir ahmed

Correct answer is B

Nassim

Nassim

CDE are correct
https://docs.oracle.com/database/121/DBSEG/audit_config.htm#DBSEG356

Oracle Database provides five predefined unified audit policies, which cover commonly used security-relevant audit settings.

Topics:

Logon Failures Predefined Unified Audit Policy
Secure Options Predefined Unified Audit Policy
Oracle Database Parameter Changes Predefined Unified Audit Policy
User Account and Privilege Management Predefined Unified Audit Policy
Center for Internet Security Recommendations Predefined Unified Audit Policy
Oracle Database Real Application Security Predfined Audit Policies
Oracle Database Vault Predefined Unified Audit Policy