In which of the situation it is not possible to fire a DML trigger, when

Options
- A row is inserted into a table
- A row in a table is updated.
- A row in a table is deleted
- A row is selected

CORRECT ANSWER : A row is selected

Discussion Board
DML Trigger

It is not possible to fire a DML trigger, when a row is selected. Triggers are implicitly fired by Oracle when a triggering event occurs, no matter which user is connected or which application is being used. DML triggers for event publication are associated with a table. They can be either BEFORE or AFTER triggers that fire for each row on which the specified DML operation occurs. You cannot use INSTEAD OF triggers on views to publish events related to DML statements—instead, you can publish events using BEFORE or AFTER triggers for the DML operations on a view's underlying tables that are caused by INSTEAD OF triggers.

Prajakta Pandit 02-22-2017 05:30 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲