Database - Advanced SQL - Discussion

Discussion Forum : Advanced SQL - General Questions (Q.No. 5)
Which of the following statements is true concerning routines and triggers?
Both consist of procedural code.
Both have to be called to operate.
Both run automatically.
Both are stored in the database.
Answer: Option
No answer description is available. Let's discuss.
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.

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:

Your comments will be displayed after verification.