SQL (Structured Query Language) Question:

Download Job Interview Questions and Answers PDF

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.

Download SQL Interview Questions And Answers PDF

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