Which statement is true regarding routines and triggers?

DWQA QuestionsCategory: SQLWhich statement is true regarding routines and triggers?
Editor Staff asked 9 months ago

Which statement is true regarding routines and triggers?

  1. Both run automatically.
  2. Both are stored in the database.
  3. Both consist of procedural code.
  4. Both have to be called to operate.
1 Answers
Editor Staff answered 9 months ago

Answer: 
3. Both consist of procedural code.
Explanation:
Routines, also known as subroutines, are the group of multiple commands that can be called whenever required.
Triggers are a special type of stored procedure containing a set of SQL statements that will be fired automatically whenever any database event occurs. It always resides in the system catalog.
So option C is the correct choice.