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;
/

Define join types.

1005

---

What are the advantages of database management system?

994

---

Where is the database stored?

947

---

What is the purpose of normalisation?

1031

---

Enlist various types of interactions created by dbms?

1069

---

What is database url?

1043

---

How big is a big database?

933

---

What is a 3nf table?

939

---

How to create student table through query with a numeric column of ID and Name of Chaeacter and D-O-B with date type in database What will be the query for this purpose?

1061

---

State at least four kinds of indexing?

1085

---

What is sql rdbms?

1008

---

Explain the concepts of a primary key and foreign key.

941

---

What is the advantages and disadvantages of database management system?

1065

---

What is the main purpose of a database?

976

---

What is database management system with example?

1073

---