nerdexam
Oracle

1Z0-062 · Question #137

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 database auditing can audit DDL statements and references to standalone stored procedures, giving broad coverage over both schema changes and procedural code execution.

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

How the community answered

(33 responses)
  • A
    88% (29)
  • C
    3% (1)
  • D
    9% (3)

Why each option

Standard database auditing can audit DDL statements and references to standalone stored procedures, giving broad coverage over both schema changes and procedural code execution.

ADDL statements can be audited.Correct

Standard database auditing supports auditing DDL statements such as CREATE, DROP, and ALTER, allowing administrators to track schema modification activities by any database user.

BStatements that refer to standalone procedure can be audited.Correct

Standard database auditing can audit statements that invoke standalone procedures, functions, and packages by using the AUDIT statement with the relevant schema object name, capturing who executed the procedural code and when.

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

Operations performed by users connected as SYSDBA or SYSOPER are audited through mandatory auditing, which writes records to the operating system audit trail or a dedicated location regardless of standard audit settings.

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

Multiple audit records can be generated per session for the same audited statement depending on whether the BY ACCESS option is used; BY SESSION produces one record per session while BY ACCESS produces one record per occurrence.

Concept tested: Standard database auditing scope for DDL and stored procedures

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

Topics

#standard auditing#DDL auditing#procedure auditing#SYSDBA auditing

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice