Oracle Database 12c: Advanced Administration — Question 111

Which two statements are true about unified auditing?

Answer options

• A. A unified audit trail captures audit information from unified audit policies and audit settings.
• B. Unified auditing is enabled by executing make-fins_rdbms.mk uniaud_onioracle ORACLE_HOME=SORACLE_HOME.
• C. Audit records are created for all users except sys.
• D. Audit records are created only for the DML and DDL operations performed on database objects.
• E. Unified auditing is enabled by setting the audit_trail parameter to db, extended.
• F. A unified audit trail resides in a read-only table in the audsys schema in the system tablespace.

Correct answer: A, F

Explanation

Statements A and F are correct because a unified audit trail does indeed capture information from unified audit policies and is stored in a read-only table in the audsys schema. Options B, C, D, and E are incorrect as they misrepresent how unified auditing operates, including specifics about enabling it and the scope of audit records.