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 phantom deadlock.

935

---

what are the different kinds of indexing?

935

---

What is dbms_output put_line?

859

---

What are the different types of modeling?

861

---

Explain what are service-specific middleware?

915

---

If you need to refresh a website page every time a record is updated in database, how would you do it?

892

---

What is dbms function?

934

---

What is type of end users?

753

---

What do databases contain?

887

---

What is a field in database?

856

---

How do you start a database?

857

---

What is sql in dbms?

926

---

How index hunting contributes in improving the query performance?

896

---

What will be the maximum size of an extent of a segment if the tablepac's default storage values are specified as (initial 8K next 16k minextent 4 pctincrease 100).Explain.

1851

---

Explain about cursors?

990

---