Part A: Indicate if the following ten statements are True or False. If the answer is False, explain why in complete sentences.
_____ 1. The OF clause for the CREATE TRIGGER statement specifies the table the trigger affects.
_____ 2. In SQL Server, you can define unlimited INSTEAD OF triggers per INSERT, UPDATE, or DELETE statement.
_____ 3. SQL Server 2000 does allow references to TEXT, NTEXT, or IMAGE columns in the DELETED table.
_____ 4. Many companies frequently abandon built-in features of the database for homegrown solutions to perform the same tasks.
_____ 5. When implementing the Simple Auditing Model 2 with Oracle, you do not need to create a sequence object for the AUDIT_DATA_ID column.
_____ 6. The AUDIT_CHECK function from the PKG_APP_AUDIT returns a VARCHAR2 value.
_____ 7. The INSERT_DATA function from the PKG_APP_AUDIT returns a BOOLEAN value.
_____ 8. There is only one way to implement the Simple Auditing Model 2 with Oracle.
_____ 9. Business requirements often mandate that you keep an audit trail of all application errors caused by data manipulation.
_____ 10. You should always consider your business requirements before deciding which designs are best for your environment.
Part B: Answer the following questions with a narrative response in complete sentences.
Note: You will need to submit responses to the questions including all the SQL scripts that you may have created. You also must provide screen shots of specific portions of the work you have done, especially the final results and some important intermediate steps.
To make a screen shot for Word, use the following steps:
* Have the image you want to copy visible on your computer screen.
* Simultaneously, hold down the Control (Ctrl), Alternate (Alt) and Print Screen (PrntScrn) keys on your keyboard.
* Go to an open Word Document
* Paste the image (either right click on your mouse and choose the Paste option, or simultaneously hold down the Control (Ctrl) and V keys.
* Resize the image by clicking and holding on one corner, then dragging the box size toward the center of the image (make sure the entire image is visible on a single page).
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.
Last Completed Projects
| topic title | academic level | Writer | delivered |
|---|