Give an example of an application where SQL triggers could be used for a purpose other than just maintaining integrity constraints.
What will be an ideal response?
When something unusual happens during the execution of a transaction, a trigger can be used to initiate another transaction, which will report the unusual event to the system administrator or take a corrective action.
Computer Science & Information Technology
You might also like to view...
If you assign an alias to one table in a join, you have to
A. use that name for the table B. assign them to all of the tables C. qualify all of the column names for that table D. qualify every column name in the query
Computer Science & Information Technology
When you create an array variable, memory space is automatically reserved.
Answer the following statement true (T) or false (F)
Computer Science & Information Technology