Unit 5 Flashcards
A FOR trigger is the same as an AFTER trigger.
true
A trigger can be set to fire after the action query (AFTER) or instead of the action query (INSTEAD OF).
true
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
You can invoke a trigger directly.
false
A view can’t have an AFTER trigger.
true
A table or view can have only one ______________ trigger.
INSTEAD OF
The ________ table contains the original rows for delete and update operations.
Deleted
How would you code the INSTEAD OF clause for a trigger that’s fired whenever a view is deleted?
INSTEAD OF DROP_VIEW
A trigger can pass back a return value.
False
If you delete a stored procedure, function, or trigger and then create it again
you delete the security permissions assigned to the object
The ________ table contains the new rows for insert and update operations.
Inserted
How would you code the ON clause for a trigger that’s fired after a table is deleted from the current database?
ON DATABASE
Each of the following statements about triggers is true except for one. Which one?
A trigger can’t be directly called or invoked.
A trigger doesn’t accept input or return output parameters.
A trigger can have more than one batch.
The code of a trigger can execute in place of the action query to which it’s assigned.
A trigger can have more than one batch.
A _______ is a special kind of procedure that executes, or fires, in response to an action query.
trigger
You can pass parameters to a trigger.
false
