Question: Provide the SQL code/statements Create a table with two columns. You have to audit all SQLstatements on your table. To do this you will write

Provide the SQL code/statements

Create a table with two columns.

You have to audit all SQLstatements on your table. To do this you will write two triggers: 1. To log any SQLstatements that users might run on this table. The results must be stored in the First Initial _ Last Name _ Log table. The table should have unique event ID, values for both the Oracle and the system user who ran the query, the time it was executed and the type of SQL query user ran.

2. To capture any data that was changed in the table. The results must be stored in the First Initial _ Last Name _ History table The table should reference the event ID from the log table, and store both old and new values for both columns.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Create a table with two columns. Name the table First Initial _ Last Name (e.g. John Dow will create table j_dow). You have to audit all SQL statements on your table. To do this you write two...

DO NOT COPY AND PASTE AN Answer from a similar question. IN 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 to...

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 to audit all DML statements on your table. To do this you write...

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

please help with the following oracle pl/sql questions: Create a table with two columns. Name the table First Initial _ Last Name (e.g. John Dow will create table j_dow). You have to audit all DML...

In SQL/pl/sql code , Create a table with two columns. Name the table First Initial _ Last Name (e.g. John Dow will create table j_dow). You have to audit all DML statements on your table. To do this...

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

1. Create a table with two columns. Name the table First Initial _ Last Name. Using Oracle SQL TABLES THAT I CREATED Table 1 CREATE TABLE a_will( Id int NOT NULL PRIMARY KEY, FirstName varchar(50)...

ome 1. Using DOS-based Orade SQL to create a table (table name must be your la (e.g, Kwang Lee-> KLEE). The table must indlude following columns (fields): CWID -. Name -. Date of Birth . Address ....

Project: Relational Modeling Note: This project must be unique in its design (E-R diagram) and implementation (SQL queries). You are not to copy or use any part of a database project that was...

Suppose that the production function is f(x1, x2) = Cxa1 xb2, where a, b, and C are positive constants. (a) For what positive values of a, b, and C are there decreasing returns to scale? _______....

Flacco, CPA, conducted the audit of Raven Company and issued an unmodified opinion that concluded that the financial statements presented its financial condition, results of operations, and cash...

1. What is the present worth of Rs 15,000 to be received seven years from now if the prevailing rate of interest is 11 per cent?

CT Corp Comprehensive Question Canadian Tire Corporation, Limited ( Canadian Tire ) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

2. Are you varying your pitch (to avoid being monotonous)?

8. Do you animate your facial expressions as you deliver your speech?

3. Are you varying your speaking rate and volume?