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.
Non Verbal Reasoning Questions and Answers for Bank Exams More
tnpsc vao chemistry question paper with answers More
TNPSC Group 2a Study Material in Tamil and English Pdf More
1000+ Classification Non Verbal Reasoning Questions and Answers More
1000+ Non Verbal Reasoning Classification Questions and Answers Pdf More
1000+ Stoichiometry Objective Questions and Answers Pdf More
1000+ Business Management Questions and Answers Pdf More
1000+ Online Computer Science Quiz Test More
1000+ Ethiopia Puzzles Funny Brain Teasers, Riddles with Answers More
100+ Reconstruction of Paragraph Questions and Answers More