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.