PL/SQL Questions Asked in Interview

When a trigger is associated to a view, the base table triggers are normally enabled. In PL/SQL, a trigger cannot be directly associated with a view. Triggers are typically associated with tables and are used to automatically execute a set of PL/SQL statements in response to specific events on the table, such as INSERT, UPDATE, … Read more

A trigger is automatically executed without any action required by the user, while, a stored procedure is explicitly invoked by the user. In PL/SQL, triggers and stored procedures serve different purposes, and there are several key differences between their execution: Trigger Execution: Triggers are automatically executed or fired in response to specific events on a … Read more

There are 12 types of triggers in PL/SQL that contains the combination of BEFORE, AFTER, ROW, TABLE, INSERT, UPDATE, DELETE and ALL keywords. BEFORE ALL ROW INSERT AFTER ALL ROW INSERT BEFORE INSERT AFTER INSERT etc. In PL/SQL, there are two main types of triggers: Row-level triggers: These triggers are fired once for each row … Read more

12 triggers. In PL/SQL, there is no predefined maximum limit on the number of triggers you can apply to a single table. However, keep in mind that each trigger you define for a table adds to the overall complexity of the database and can impact performance. While there is no strict limit on the number … Read more

A trigger is a PL/SQL program which is stored in the database. It is executed immediately before or after the execution of INSERT, UPDATE, and DELETE commands. In PL/SQL, a trigger is a set of instructions that are automatically executed (“triggered”) in response to specific events on a particular table or view. These events include … Read more