ORACLE DATABASE INTERVIEW QUESTIONS

What is a database trigger in Oracle?

How do you create a simple trigger in Oracle?

What are the types of triggers available in Oracle?

How do you reference the old and new values in a trigger in Oracle?

How do you disable and enable a trigger in Oracle?

Can you explain the difference between statement-level and row-level triggers?

How do you handle mutating table errors in Oracle triggers?

How do you create an INSTEAD OF trigger on a view in Oracle?

What is a compound trigger, and how is it used in Oracle?

Explain how you would create and use a trigger to enforce a business rule in Oracle?