Multiple choice

For which of the following SQL statements can a trigger not be written?

  1. Alter

  2. Update

  3. Delete

  4. Insert
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

A trigger is a PL/SQL block structure, which is fired when DML statements like Insert, Delete, Update are executed on a database table. 'Alter' is not a DML statement but a DDL statement that is used to alter or change the structure of a table like adding, dropping and resizing a column. We cannot write a trigger for a DDL command.

Keep practicing — related questions