Auditing Features  «Prev  Next»

Auditing privileges and database objects - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 
1. If you wanted to created an audit record every time someone selected rows from the COIN table in the COIN schema, which of the following statements would you use?
Please select all the correct answers.
  A. AUDIT SELECT ON COIN.COIN
  B. AUDIT SELECT ON COIN.COIN WHEN SUCCESSFUL
  C. AUDIT SELECT ON COIN.COIN BY SESSION
  D. AUDIT SELECT ANY TABLE ON COIN.COIN

2. Which of the following statements will not create an audit record each time someone logs onto the database?
Please select all the correct answers.
  A. AUDIT ALL PRIVILEGES
  B. AUDIT DBA
  C. AUDIT CONNECT
  D. AUDIT CREATE SESSION

3. To get rid of some rows from the audit trail, which command would you use?
Please select the best answer.
  A. PURGE AUDIT
  B. DELETE AUDIT
  C. DELETE * FROM SYS.AUD$ WHERE . . .
  D. You cannot get rid of part of an audit trail.