SQL (Structured Query Language) Question:

What is SQL Mutating Table?

SQL Interview Question
SQL Interview Question

Answer:

Mutating Table is a table that is currently being modified by an Insert, Update or Delete statement. Constraining Table is a table that a triggering statement might need to read either directly for a SQL statement or indirectly for a declarative Referential Integrity constraints. Pseudo Columns behaves like a column in a table but are not actually stored in the table. E.g. Currval, Nextval, Rowid, Rownum, Level etc.


Previous QuestionNext Question
What is SQL Rollback?Operators used in SELECT statements.