16 Quiz
Each of the following statements about triggers is true except for one. Which one is it? A trigger responds to an INSERT, UPDATE or DELETE statement. In MySQL, you must specify a FOR EACH ROW clause. A trigger responds to the event scheduler. A trigger can work with the new or old values in a row.
A trigger responds to the event scheduler.
To insert rows into an audit table, you typically use a/an BLANK trigger.
AFTER
Triggers can be used to enforce rules for data consistency that can't be enforced by BLANK.
CONSTRAINTS
Which of the following is the beginning of a trigger named customers_after_insert that's executed after an INSERT statement on the table named customers? CREATE TRIGGER customers_after_invoices AFTER INSERT customers CREATE TRIGGER customers_after_invoices AFTER INSERT ON customers CREATE TRIGGER customers INSERT AFTER ON customers CREATE TRIGGER customers AFTER INSERT customers_after_invoices
CREATE TRIGGER customers_after_invoices AFTER INSERT ON customers
To code an event that executes every month, you would use the ______________ keyword. SET EVERY AT GLOBAL
EVERY
A trigger is a named block of code that executes, or BLANK, in response to an INSERT, UPDATE, or DELETE statement.
FIRES
To create a row-level trigger, you must code the BLANK clause.
FOR EACH ROW
When you use a BEFORE trigger to work with an UPDATE statement, you can use the BLANK keyword and a column name to refer to a value in the row before it is updated.
OLD
An event can be a one-time event that occurs only once or a BLANK event that occurs regularly at a specified interval.
RECURRING
MySQL only supports BLANK triggers.
ROW-LEVEL
An event executes according to the event BLANK.
SCHEDULER
To turn the event scheduler on or off, you can use the BLANK statement.
SET
You would use a trigger for all but one of the following. Which one is it? to add rows to an audit table to create an audit table to enforce data consistency to store information about actions that occur in the database
to create an audit table
