What are the various types of database triggers ?

1. What are the various types of database triggers ?

Answer:   There are 12 types of triggers they are combination of:

Insert, delete and update triggers.

Before and after triggers .

Row and statement triggers

2.What is advantage of a stored procedure over a database trigger?

3. What is the use of control files ?

Answer: contains pointers to locations of various data files, redo log files, etc.

Answer: we have control over the firing of stored procedure but we have no control over the firing of trigger 

4.What is maximum no. of statements that can be specified in trigger statement?

Answer: one 

5.Can views be specified in trigger statement?

Answer: no

6.To Find a Last Record From Table

Select * from employees where ROWID in(select max(Rowid)from employees);