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.