Top 100+ PL/SQL Interview Questions and Answers Pdf - 1
What are schema-level triggers?
Schema-level triggers are created on schema-level operations, such as create table, alter table, drop table, rename, truncate, and revoke.
These triggers prevent DDL statements, provide security, and monitor the DDL operations.
What is the different between row level triggers and statement level triggers?
Row level triggers are generally used for data auditing applications.
Statement level triggers are used to enforce security features for the types of actions that may be performed on a table.
Can cursors be part of a triggers body?
Yes, cursors can be a part of code in trigger.
What are conditional predicates?
Triggers use conditional predicates, such as INSERTING, UPDATING, and DELETING, to determine which particular event will cause the triggers to fire. All the three predicates have Boolean values and are useful in triggers, such as AFTER INSERT or UPDATE.
What is a mutating table?
A mutating table is a table, which is in the state of transition. In other words, it is a table, which is being updated at the time of triggering action. If the trigger code queries this table, then a mutating table error occurs, which causes the trigger to view the inconsistent data.
1000+ Civil Engineering Multiple Choice Questions and Answers More
1000+ Surveying MCQ Questions and Answers Pdf More
1000+ Surveying Objective Questions and Answers Pdf More
100+ Surveying Multiple Choice Questions and Answers Pdf More
1000+ Surveying Questions and Answers Pdf More
Top 1000+ One Word Substitution Exercise with Answers More
100+ Geography The Sun, Earth, Solar System Quiz Questions More
Staroffice MCQ Questions and Answers More
Operating System Multiple Choice Questions and Answers More
100+ Interesting Biology Questions and Answers More