Unit 5

A trigger can pass back a return value.

False

You can invoke a trigger directly.

False

You can pass parameters to a trigger.

False

A table or view can have only one ______________ trigger.

INSTEAD OF

How would you code the INSTEAD OF clause for a trigger that's fired whenever a view is deleted?

INSTEAD OF DROP_VIEW

The ________ table contains the new rows for insert and update operations.

Inserted

Within a trigger, you can refer to two tables that are created by the system: _______________

Inserted and Deleted

How would you code the ON clause for a trigger that's fired after a table is deleted from the current database?

ON DATABASE

A _______ is a special kind of procedure that executes, or fires, in response to an action query.

trigger

If you delete a stored procedure, function, or trigger and then create it again

you delete the security permissions assigned to the object

A FOR trigger is the same as an AFTER trigger.

True

A table can have multiple AFTER triggers, even for the same action.

True

A trigger can be set to fire after the action query (AFTER) or instead of the action query (INSTEAD OF).

True

A trigger is associated with a single table or view, which you identify in the ON clause.

True

A view can't have an AFTER trigger.

True

trigger

a special type of stored procedure that's executed automatically when an insert, update, or delete operation is executed on a table or when a DDL statement is executed on a database.

data definition language (DDL)

lets you work with objects in a database; database administrators (DBAs) use this

data manipulation language (DML)

lets your work with the data in the database; SQL programmers typically work with this

Each of the following statements about triggers is true except for one. Which one?

A trigger can have more than one batch.

The ________ table contains the original rows for delete and update operations.

Deleted

If you want to prevent users from examining the SQL code that defines a procedure, function, or trigger, you code the CREATE statement with the ________________ option

ENCRYPTION