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.
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)- A94% (44)
- C2% (1)
- D4% (2)
Why each option
Standard Oracle database auditing supports both DDL statements and statements referencing standalone stored procedures as auditable objects.
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.
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.
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.
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
Community Discussion
No community discussion yet for this question.