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

Discussion

A ________ is a stored program that is attached to a table or a view.

  • A.pseudofile
  • B.embedded SELECT statement
  • C.trigger
  • D.None of the above is correct.

Answer: C

Correct answer: trigger

A trigger is a stored program attached to a particular table or view and fired automatically when a specified event occurs on it - an insert, update or delete. The attachment is what distinguishes it from a stored procedure, which belongs to the database as a whole and must be called explicitly.

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

Post your comment

Please log in or register to post a comment.