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

To delete or remove a trigger

Answer 2

DROP TRIGGER

Question 3

A —— is invoked before or after a data row is inserted, updated, or deleted.

Answer 3

trigger

Question 4

true or false: can a database table may have one or more triggers.

Answer 4

true

Question 5

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

Answer 5

DELIMITER

Question 6

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 6

BEFORE

Question 7

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

Answer 7

AFTER

Question 8

trigger is used for insert operation

Answer 8

INSERT

Question 9

trigger is used for update operation

Answer 9

UPDATE

Question 10

trigger is used for delete operation

Answer 10

DELETE

Question 11

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

Answer 11

FOR EACH ROW

Question 12

enable you to access columns in the rows affected by a trigger.

Answer 12

the OLD and NEW keywords

Question 13

2 types of triggers

Answer 13

• Data Manipulation Language (DML) trigger
• 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