BUSINESS ADMINISTRATION
BUSINESS POLICY
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Declarative processing depends on rules like data transforms, etc.
|
|
|
Procedural processing is easy to configure and maintain.
|
|
|
Procedural processing depends on rules like declare expressions.
|
|
|
With declarative processing, updates occur only when triggered in the application.
|
Detailed explanation-1: -The correct is option 4. Trigger is a statement that is executed automatically by the system as a side effect of modification to the database. Trigger has three parts: Trigger statement or event is the SQL statement that causes a trigger to be fired.
Detailed explanation-2: -Which statement about triggers is true? You use an application trigger to fire when a DELETE statement occurs. You use a database trigger to fire when an INSERT statement occurs. You use a system event trigger to fire when an UPDATE statement occurs.
Detailed explanation-3: -A BEFORE triggered action executes before the triggering statement, that is, before the occurrence of the trigger event. An AFTER triggered action executes after the action of the triggering statement is complete.
Detailed explanation-4: -In SQL Server, you can create DML triggers that execute code only when a specific column is updated. The trigger still fires, but you can test whether or not a specific column was updated, and then run code only if that column was updated. You can do this by using the UPDATE() function inside your trigger.