Top 100+ PL/SQL Interview Questions and Answers Pdf - 2

Question: 6

Which data manipulation operations raise a trigger?

Data manipulation operations such as INSERT, UPDATE, and DELETE on a table or view are the main triggering events that cause a trigger to execute.

Question: 7

What is a database event trigger?

Trigger that is executed when a database event, such as startup, shutdown, or error, occurs is called a database event trigger. It can be used to reference the attributes of the event and perform system maintenance functions immediately after the database startup.

Question: 8

Does a USER_OBJECTS view have an entry for a trigger?

Yes, the USER_OBJECTS view has one row entry for each trigger in the schema.

Question: 9

What is a CALL statement?

A CALL statement within a trigger enables you to call a stored procedure within the trigger rather than writing the Procedural Language/Structured Query Language (PL/SQL) code in it. The procedure may be in PL/SQL, C, or Java language.

Question: 10

What are instead of triggers?

The INSTEAD OF TRIGGERS are used in association with views. The standard table based triggers cannot be used by views. These triggers inform the database of what actions are to be performed instead of the actions that invoked the trigger. Therefore, the INSTEAD OF triggers can be used to update the underlying tables, which are part of the views. They can be used on both relational views and object views. The INSTEAD OF triggers can only be defined as row level triggers and not as statement level triggers.

Related Questions