Question

Create a trigger on student(s_id,fname,course) table, which inserts data in stud_audit(s_id,status,date) if any DML operation occurs on student table and put corresponding status – updated, inserted or deleted in status and date.​

Answer 1

Answer:

Table auditing means keeping a track of all the dml activities performed on a specific table of the database for example which user Inserted, updated or deleted a row from the table and when. It is like spying on the users who are messing your table’s data.

Explanation:

For the demonstration we will use the table ‘Superheroes’ which we created in the previous tutorial.

Suppose you want to keep an eye on the users who are inserting, updating or deleting data from the ‘Superheroes’ table. Let’s see how we can achieve this. To do so we will need another table in which we can journal the auditing data entries.