Answer Posted / khushal

The oracle table can have the 12 Trigger associated with it.

-- before constraints are applied

1) BEFORE INSERT STATEMENT LEVEL
2) BEFORE INSERT ROW LEVEL
3) BEFORE UPDATE STATEMENT LEVEL
4) BEFORE UPDATE ROW LEVEL
5) BEFORE DELETE STATEMENT LEVEL
6) BEFORE DELETE ROW LEVEL


7) AFTER INSERT STATEMENT LEVEL
8) AFTER INSERT ROW LEVEL
9) AFTER UPDATE STATEMENT LEVEL
10) AFTER UPDATE ROW LEVEL
11) AFTER DELETE STATEMENT LEVEL
12) AFTER DELETE ROW LEVEL

State the various uses of dbcc command?

995

---

What is the usage of control file in oracle?

1032

---

Can we use bind variables in oracle stored procedure?

904

---

What is procedure overloading in oracle?

1001

---

What is pragma autonomous transaction in oracle?

1004

---

What are the different types of trigger and explain its various uses and functions?

1020

---

what is Single Byte Overhead...?

2506

---

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1016

---

How to create an initialization parameter file?

995

---

How to convert csv to table in oracle?

933

---

How do I use unicode codesets with the weblogic jdriver for oracle driver?

1028

---

Why does for update in oracle 8 cause an ora-01002 error?

945

---

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2311

---

Explain coalesce function?

1133

---

How to define a variable of a specific record type?

1024

---