Question 1 :
What are the types of processes that a server runs ?
Foreground process and Background process.
Question 2 :
What is a event handler ?
An event handler is a routine that is written to respond to a particular event.
Question 3 :
What is an integrity constraint ?
An integrity constraint allows the definition of certain restrictions, at the table level, on the data that is entered into a table.
Question 4 :
What are the various uses of database triggers ?
Database triggers can be used to enforce business rules, to maintain derived values and perform value-based auditing.
Question 5 :
What is a transaction ?
A transaction is a set of operations that begin when the first DML is issued and end when a commit or rollback is issued. BEGIN COMMIT/ROLLBACK are the boundries of a transaction.