Oracle SQL:

Create a table with two columns. Name the table First Initial _Last Name (e.g. John Dow will create table j_dow). You have toaudit all DML statements on your table. To do this you write twotriggers:

1. To log any DML statements that users mightrun on this table. The results must be stored in the First Initial_ Last Name _ Log table (e.g. John Dow will create tablej_dow_log).

The table should have unique event ID, values for both theOracle and the system user who ran the query, the time it wasexecuted and the type of DML query user ran.

2. To capture any data that was changed in thetable. The results must be stored in the First Initial _ Last Name_ History table (e.g. John Dow will create tablej_dow_history).

The table should reference the event ID from the log table, andstore both old and new values for both columns.

What to submit: Name this file according to submissionguidelines and include the following answers:

Code to create all three tables, constraints, insertstatements. (10 points)

Code for the first trigger (10 points)

Test cases and expected results for the first trigger(30 points)

Code for the second trigger (10 points)

Test cases and expected results for the first trigger(30 points)

Answer rating: 100% (QA)

Certainly Heres an example of how you can create the tables constraints and triggers in Oracle SQL based on your requirements sql Copy code Create the ... View the full answer