Answer / nilesh

There are 2 types of triggers as per the execution goes
they are ROW LEVEL and STATEMENT LEVEL TRIGGERS

Then as per action triggers can be executed for three
actions as INSERT, UPDATE and DELETE

and trigger can also be executed before the action or after
the action . So with this we can have 12 diffrent triggers
they are: (6 Row level, 6 statement level)

ROW LEVEL
AFTER INSERT , BEFORE INSERT (2 Nos.)
AFTER UPDATE , BEFORE UPDATE (2 Nos.)
AFTER DELETE , BEFORE DELETE (2 Nos.)

STATEMENT LEVEL
AFTER INSERT , BEFORE INSERT (2 Nos.)
AFTER UPDATE , BEFORE UPDATE (2 Nos.)
AFTER DELETE , BEFORE DELETE (2 Nos.)

Answer / biswajit biswal

We can specified 28 Database triggers on a single table.

Before Row level insert
After Statement level update
Delete
insert or update
update or delete
insert or delete
insert or update or delete

2*2*7=28

what is the correct way of selection statement a. select/from/table_name/orderby/groupby/having b. select/from/table_name/groupby/having/orderby

5 Answers   HCL, JPMorgan Chase,

---

what is the differnce between procedure and function? in both dml operations can work and in procedure through out parameter you can return value ,then what is the differce?

3 Answers   3i Infotech,

---

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

0 Answers  

---

What is the diff between Truncate table / delete <table name> purge

3 Answers   TCS,

---

What are the default Oracle triggers??

3 Answers   CGI, Tech Mahindra,

---

Do we need to create index on primary key?

0 Answers  

---

what are the drivers in mysql? : Sql dba

0 Answers  

---

how many groups of data types? : Sql dba

0 Answers  

---

how can we find the select statement is indexed or not?

3 Answers   CTS,

---

why should required for Indexed by table in pl/sql

3 Answers  

---

select 10 from dual; y its showing all the rows with 10?

1 Answers  

---

if a table is getting updated what happens if a function is called from sql query?

2 Answers   RBS,

---