nerdexam
Oracle

1Z0-052 · Question #117

Which two statements are true about standard database auditing? (Choose two.)

The correct answer is A. DDL statements can be audited. B. Statements that refer to standalone procedure can be audited. Standard Oracle database auditing supports both DDL statements and statements referencing standalone stored procedures as auditable objects.

Implementing Oracle Database Auditing

Question

Which two statements are true about standard database auditing? (Choose two.)

Options

  • ADDL statements can be audited.
  • BStatements that refer to standalone procedure can be audited.
  • COperations by the users logged on as SYSDBA cannot be audited.
  • DOnly one audit record is ever created for a session per audited statement even though it is executed

How the community answered

(47 responses)
  • A
    94% (44)
  • C
    2% (1)
  • D
    4% (2)

Why each option

Standard Oracle database auditing supports both DDL statements and statements referencing standalone stored procedures as auditable objects.

ADDL statements can be audited.Correct

Oracle standard auditing allows DDL statements such as CREATE, ALTER, DROP, and TRUNCATE to be audited using the AUDIT command, making this a true statement about standard auditing capabilities.

BStatements that refer to standalone procedure can be audited.Correct

Oracle standard auditing supports statement-level auditing that targets calls to standalone stored procedures and functions, so auditing statements that reference a standalone procedure is valid and supported.

COperations by the users logged on as SYSDBA cannot be audited.

This is false - SYSDBA operations can be audited by setting the AUDIT_SYS_OPERATIONS initialization parameter to TRUE, which writes SYS audit records to the OS audit trail.

DOnly one audit record is ever created for a session per audited statement even though it is executed

This is false because the number of audit records created depends on whether BY SESSION or BY ACCESS auditing is configured - BY ACCESS creates one record per execution, not a single record per session regardless of execution count.

Concept tested: Oracle standard database auditing capabilities

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/dbseg/configuring-audit-trails.html

Topics

#standard auditing#DDL auditing#SYSDBA auditing#audit records

Community Discussion

No community discussion yet for this question.

Full 1Z0-052 Practice