RelationalDBDesignRelationalDBDesign


Auditing Features  «Prev 

Auditing SQL statements - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 
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.

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.

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
Score =
Correct answers: