UNIT 6

Question 1

a procedural SQL code that is automatically invoked by the RDBMS upon the occurrence of a given data manipulation event.

Answer 1

Trigger

Question 2

A TRIGGER is created using the __________ command.

Answer 2

CREATE TRIGGER

Question 3

It cannot be created on a view, temporary table or system table, but they can reference views or temporary tables

Answer 3

trigger

Question 4

To delete or remove a trigger we use what command

Answer 4

DROP TRIGGER trigger_name

Question 5

replaces the existing line ender (;) with the provided symbol. Used for END statement.

Answer 5

Delimiter

Question 6

Delimiter is used in what kind of statement

Answer 6

End statement

Question 7

is used if we want to execute the trigger before changes are made to the table. Meaning it will be executed regardless of a successful operation.

Answer 7

BEFORE

Question 8

is used if we want to execute the trigger before changes are made to the table.

Answer 8

AFTER

Question 9

trigger is used for insert operation

Answer 9

INSERT

Question 10

trigger is used for update operation

Answer 10

UPDATE

Question 11

trigger is used for delete operation

Answer 11

DELETE

Question 12

indicates that the trigger will be in effect for all the row changes made inside the table

Answer 12

FOR EACH ROW

Question 13

What are the 2 types of triggers

Answer 13

Data Manipulation Language (DML) trigger
and
Data Definition Language (DDL) trigger

Question 14

Executes when INSERT, UPDATE, and DELETE commands modify data in a table or view.

Answer 14

Data Manipulation Language (DML) trigger

Question 15

Executes in response to a DDL statement that is often used to make database schema changes. Examples include the CREATE, ALTER, and DROP statements.

Answer 15

Data Definition Language (DDL) trigger