Auditing SQL statements - Quiz Explanation
The correct answers are indicated below, along with text that explains the correct answers.
1.
Which of these statements about the number of audit records created is most accurate?
Please select the best answer.
A.
Using
BY SESSION
usually creates more audit records.
B.
Using
BY ACCESS
usually creates more audit records.
C.
Both types of auditing always create the same number of records.
D.
Using
BY ACCESS
always creates more audit records.
Answer B is correct.
Typically, using
BY ACCESS
will create more audit records, because it will create an audit record for each individual access. However, if each session contains only a single access, both
BY ACCESS
and
BY SESSION
will create the same number of records.
2.
Which statement is true about the type of events you can audit?
Please select the best answer.
A.
You can audit all events in a database.
B.
You can track only successful or unsuccessful SQL statements, not both.
C.
You can track successful, unsuccessful, or both types of SQL statements.
D.
You can track successful, unsuccessful, invalid, or all types of SQL statements.
Answer C is correct.
Although you can track successful, unsuccessful, or both types of SQL statements, you cannot audit invalid SQL statements.
3.
Which of these data dictionary views lists all available audit records for the current user?
Please select the best answer.
A.
USER_AUDIT_TRAIL
B.
USER_AUDIT_SESSION
C.
USER_AUDIT_STATEMENT
D.
USER_AUDIT_OBJECT
Answer A is correct.
The other three data dictionary views display subsets of available audit records.