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.
GATE Chemical Engineering Questions and Answers More
GATE 2024-2025 Question Paper Pdf Download More
Banking Awareness Questions 2024-2025 More
Computer Quiz Questions for Bank Exams More
Computer Quiz Questions for Bank Exams More
1000+ Mechanical Engineering Question Paper Pdf Free Download More
1000+ C Questions and Answers Pdf More
UPSC, SSC Questions on Chola Dynasty More
7000+ Indian Polity Quiz Questions for Competitive Exams Pdf More
TRB Model Question Papers with Answer in Chemistry More