Un-Answered Questions { SQL PLSQL }
Explain the uses of control file.
How can the performance of a trigger be improved?
How can you view the errors encountered in a trigger?
Explain autonomous transaction.
Can a view be mutating? If yes, then how?
Explain mutating table error.
Can cursors be part of a trigger body?
What is the importance of sqlcode and sqlerrm?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
Explain spool.
Differentiate between sga and pga.
How can triggers be used for the table auditing?
Is it possible to create startup or shutdown trigger for on-schema?
Explain commit, rollback and savepoint.
What are schema-level triggers?
