Discussion :: Advanced SQL - General Questions (Q.No.5)
| Rohini said: (Mar 20, 2012) | |
| Triggers are called implicitly so y C option is not true..? | |
| Venu said: (Apr 25, 2012) | |
| Triggers are executed automatically when an action. Modification occurs in data base. | |
| Gopi Krishna said: (Apr 21, 2016) | |
| Routines: Sometimes called subroutines are set of command which is grouped and can be called whenever required. Routines are called with perform <SUBROUT_NAME> and created with form (subroutine_name) and form. Its major function is to perform specific operation e.g. calculate interest. Parameters are passed to Subroutines. DB Triggers: This is different in term of functionality. DB Triggers are fired whenever any DB event occurs. like change, add a record, dele record. but u may call routines in triggers. So option A is the correct one. |
|
Post your comments here:
Name *:
Email : (optional)
» Your comments will be displayed only after manual approval.