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

Explain oracle instance.

1185

---

What privilege is needed for a user to delete rows from tables in another schema?

1071

---

Explain an exception?

1003

---

Calculate difference between 2 date / times in oracle sql?

1044

---

What are the general rules on data consistency?

1012

---

How to export several tables together?

1050

---

What do you mean by merge in oracle?

997

---

What is a select query statement in oracle?

972

---

How to pass a parameter to a cursor in oracle?

1187

---

How would you best determine why your MVIEW couldnt FAST REFRESH?

1892

---

How to check the oracle tns settings?

1047

---

Explain database link?

1131

---

How to load data through external tables?

1142

---

can u plz provide me oca sql dumps please i need them

1955

---

Can group functions be mixed with non-group selection fields?

1025

---