consists of procedures and functions stored in database as standalone.

block that is associated with an event that occurs in database

constructed dynamically and executed once.

none if these