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:
Email : (optional)
» Your comments will be displayed only after manual approval.