Set - 6

Question 1 :

What are the types of processes that a server runs ?

Answer :

Foreground process and Background process.

Question 2 :

What is a event handler ?

Answer :

An event handler is a routine that is written to respond to a particular event.

Question 3 :

What is an integrity constraint ?

Answer :

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 ?

Answer :

Database triggers can be used to enforce business rules, to maintain derived values and perform value-based auditing.

Question 5 :

What is a transaction ?

Answer :

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.