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 Question | Next Question |
What is SQL Deadlock? | What is SQL*Loader? |