Review Questions for
Chapter 9
1. Oracle provides specific trigger events that enable you to produce an audit trail of database applicaton errors. True or false? 2.Oracle provides specific triggers that enable auditing database activities,such as user logons and logoffs. True or false ? 3. Oracle provides only one way of auditing database startup and shutdown .True or False? 4. After the Oracle audit trail database activities are stored in the AUD# table, the audit trail records cannot be deleted .True or false ? 5. The DBA_AUDIT_TRAIL data dictionary view cannot be deleted . True or false ? 6. The Oracle AUD$ table is owned by SYSTEM .True or false? 7. Oracle provides an interface called Oracle Enterprise Manager that allows you to audit database activities.True or false? 8. Using Oracle ,shutdown and startup the database and then locate the related audit records in the alert log. 9. Briefly explain the purpose of the Oracle Alert file. |