Machine-translated by Google. Questions are authored in English.
Top

Discussion

Which of the following statements is true concerning routines and triggers?

  • A.Both consist of procedural code.
  • B.Both have to be called to operate.
  • C.Both run automatically.
  • D.Both are limited to a single SQL statement.

Answer: A

Correct answer: Both consist of procedural code.

Both are blocks of procedural code stored in the database. What separates them is how they are invoked: a routine must be called explicitly, whereas a trigger fires by itself when its event occurs. Neither option describing invocation can therefore be true of both.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.