triggers_procedures_flashcards

Question 1

What is a stored procedure?

Answer 1

Procedural SQL code stored in the database, executed with a CALL statement.

Question 2

What is a trigger?

Answer 2

A procedure that automatically executes in response to certain events on a table.

Question 3

When do triggers execute?

Answer 3

On INSERT, UPDATE, or DELETE events.

Question 4

What are the components of a trigger?

Answer 4

Trigger event, timing (BEFORE/AFTER), and level (ROW/STATEMENT).

Question 5

How do you declare a procedure in MySQL?

Answer 5

Using CREATE PROCEDURE with input/output parameters and a BEGIN…END block.

Question 6

What is the difference between a procedure and a trigger?

Answer 6

Procedures are called manually; triggers are event-driven.

Question 7

What is the use of DELIMITER in MySQL?

Answer 7

To change the statement terminator when defining procedures or triggers.

Question 8

What is NEW and OLD in triggers?

Answer 8

Pseudo-records to reference column values before/after a change.