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.