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 2

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

Answer 2

trigger

Question 3

To delete or remove a trigger we use what command

Answer 3

DROP TRIGGER trigger_name

Question 4

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

Answer 4

Delimiter

Question 4

Delimiter is used in what kind of statement

Answer 4

End statement

Question 5

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 5

BEFORE

Question 6

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

Answer 6

AFTER

Question 7

trigger is used for insert operation

Answer 7

INSERT

Question 8

trigger is used for update operation

Answer 8

UPDATE

Question 9

trigger is used for delete operation

Answer 9

DELETE

Question 10

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

Answer 10

FOR EACH ROW

Question 11

What are the 2 types of triggers

Answer 11

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

Question 12

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

Answer 12

Data Manipulation Language (DML) trigger

Question 13

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 13

Data Definition Language (DDL) trigger