What are the different types of triggers?



What are the different types of triggers?..

Answer / Brajesh Kumar

In Oracle, there are two main types of triggers: DDL Triggers (triggered by changes to the database schema, like CREATE, ALTER, or DROP statements) and DML Triggers (triggered by changes to the data in tables, like INSERT, UPDATE, or DELETE statements).

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

Can we use loop in sql?

1 Answers  


what are the methods using performance tunning in sql and pl/sql

2 Answers  


What are the most important ddl statements in sql?

1 Answers  


What is an Integrity Constraint?

4 Answers  


Does sap use sql?

1 Answers  


What is the best sql course?

0 Answers  


Can a table have no primary key?

1 Answers  


what is the difference between truncate and drop statements? : Sql dba

1 Answers  


What is difference between group by and partition by?

1 Answers  


What is clustered index in sql?

1 Answers  


What is user defined functions?

1 Answers  


Differentiate between pl/sql and sql?

1 Answers  


Categories