INTERVIEW QUESTIONS DATABASE SQL DETAILS

Question: If Delete Any Table In Back-End Then
What Are The Triggers will Fire Automatically
(Those Triggers Are Back-End Triggers Only)

Answer: Oracle has Schema triggers (CREATE OR REPLACE TRIGGER ... ON SCHEMA ... that will file on DDL commands. You can do things like

CREATE OR REPLACE TRIGGER save_our_db
BEFORE DROP OR TRUNCATE
ON SCHEMA

to stop/log attempts to drop a table

Oracle has Schema triggers (CREATE OR REPLACE TRIGGER ... ON SCHEMA ... that will file on DDL commands. You can do things like

CREATE OR REPLACE TRIGGER save_our_db
BEFORE DROP OR TRUNCATE
ON SCHEMA

to stop/log attempts to drop a table
Source: CoolInterview.com

In oracle, two triggers work when any dml command execute one for insert
, 2nd for delete.
So,When we delete any table , it's rows first being entered in temporary table of insert trigger and then be deleted.
This is how the oracle server shows the contents of table when it rollback by user. Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

• There should not be any Spelling Mistakes.
• There should not be any Gramatical Errors.
• Answers must not contain any bad words.
• Answers should not be the repeat of same answer, already approved.
• Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question