Database - Advanced SQL - Discussion
Discussion Forum : Advanced SQL - General Questions (Q.No. 5)
5.
Which of the following statements is true concerning routines and triggers?
Discussion:
3 comments Page 1 of 1.
Gopi Krishna said:
7 years ago
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.
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.
Venu said:
1 decade ago
Triggers are executed automatically when an action. Modification occurs in data base.
Rohini said:
1 decade ago
Triggers are called implicitly so y C option is not true..?
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers