Top 100+ PL/SQL Interview Questions and Answers Pdf - 1
Question: 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.
Question: 2
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.
Question: 3
Can cursors be part of a triggers body?
Yes, cursors can be a part of code in trigger.
Question: 4
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.
Question: 5
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.
7000+ TNPSC Physics Previous Year Questions Pdf Download More
7000+ DC Machines Questions and Answers Pdf More
7000+ DC Machines Multiple Choice Questions with Answers More
7000+ Synonyms and Antonyms for Banking Exams More
7000+ TNPSC General English Model Question Papers 2024 - 2025 More
1000+ Analytical Puzzles Interview Questions and Answers More
1000+ Chemical Process Industries MCQ Questions & Answers Pdf More
Top 50+ Calendar Aptitude Questions and Answers Pdf More
TNPSC Group 1, 2 Biology Model Question Paper 2019-2020 More
World Population Day Quiz Questions and Answers More