SQL and PL/SQL Question:
Download Questions PDF

What is Mutating SQL Table?

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 and PL/SQL Interview Questions And Answers PDF

Previous QuestionNext Question
What is SQL Deadlock?What is SQL*Loader?