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.
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)- A88% (29)
- C3% (1)
- D9% (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.
Standard database auditing supports auditing DDL statements such as CREATE, DROP, and ALTER, allowing administrators to track schema modification activities by any database user.
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.
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.
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
Community Discussion
No community discussion yet for this question.