Log In

You Will Need To Submit Responses To The Questions Including All The Sql Scripts

1.Use Oracle10g to modify the DML audit mode (Simple 2) to include the INSERT statement.

2.Use Oracle10g to modify the DML audit model (Simple 2) to register a type of operation applied on the row.

3.Use Oracle10g to develop a data history model based on the AFTER INSERT, UPDATE, or DELETE trigger.

4.Using the Audit Simple 1 model, modify the PL/SQL code presented for this model in the chapter to include auditing columns.

5.Using Oracle10g and any of the audit designs presented in this chapter or Chapter 7, produce an audit trail of any DML statement activities on any table belonging to a schema other than SYS or SYSTEM.

× How can I help?