A(n) ____ is a table that is being modified by a DML action when a trigger is fired.
A) system table
B) mutating table
C) transaction table
D) correlation table

Question

Quizplus · Accepted Answer

A mutating table is a table that is in the process of being modified by a DML (Data Manipulation Language) statement, such as an INSERT, UPDATE, or DELETE. Triggers that refer to mutating tables can cause errors or unexpected results, as the table is in a transitional state. Therefore, it is important to avoid using mutating tables in triggers. System tables are used by the database management system to store metadata about the database. Transaction tables are used to record the state of ongoing transactions. Correlation tables do not exist in database terminology.

A(n) ____ Is a Table That Is Being Modified by a DML