Answer Posted / ddrema

It's posible and mandatory if you use AUTONOMOUS
TRANSACTION in the TRIGGER.
like this:
CREATE OR REPLACE TRIGGER audit_sal
BEFORE UPDATE OF salary ON employees FOR EACH ROW
DECLARE
PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
INSERT INTO emp_audit VALUES( :old.employee_id, SYSDATE,
:new.salary, :old.salary );
COMMIT;
END;
/

What is the purpose of normalization in dbms?

1096

---

What is the purpose of a database?

991

---

What are the restrictions applicable while creating views?

904

---

What is join? Mention its types.

982

---

What is the relationship?

928

---

What is cliques? What is vdisk and how it will communicate with physical data storage at the time of data retrieval through amp?

825

---

What is system catalog or catalog relation?

1028

---

What is a clustered database?

850

---

Discuss some of the techniques that can be used to tune operational performance.

900

---

Define RDBMS.

1130

---

What does fill factor concept mean with respect to indexes?

890

---

What is the best free database software?

824

---

What are the four objects in a database?

985

---

What are the applications of database management system?

849

---

Explain, why is rdbms better than dbms?

949

---