Multiple choice technology databases

You suspect unauthorized data manipulation language (DML) operations on a particular table. You want to track users who performing the transactions and the values used in the transactions. Also you plan to transfer these values to another table for analysis. How would you achieve this?

  1. By auditing the all DML operations on table.

  2. By using external table.

  3. By using triggers.

  4. By using anonymous PL/SQL blocks

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Triggers are database objects that automatically execute in response to DML events (INSERT, UPDATE, DELETE). They can track who performed the operation, capture the values involved, and even transfer those values to another table - meeting all requirements in the question. Auditing only tracks that operations occurred but doesn't capture values. External tables are for accessing external data files, not capturing DML activity.