What is trigger types in sql?



What is trigger types in sql?..

Answer / Leena Rani

There are four types of SQL triggers: DDL triggers, Data Manipulation Language (DML) triggers, Logon triggers, and Logoff triggers. DDL triggers execute in response to database events such as creating or altering a table. DML triggers execute in response to data manipulation events such as inserting or updating a row in a table. Logon triggers execute when a user logs into the database, while logoff triggers execute when a user logs out of the database.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

Why use triggers in sql?

1 Answers  


How do I run sql profiler?

1 Answers  


What does sign mean sql?

1 Answers  


What is a procedure in pl sql?

1 Answers  


Give an example of any procedure.

5 Answers   Accenture, iFlex, Wipro,


What are the PL/SQL Statements used in cursor processing ?

4 Answers  


What is denormalization in a database?

1 Answers  


Explain what is a subquery ?

1 Answers  


What is using in sql?

1 Answers  


What is the use of double ampersand (&&) in sql queries? Give an example

1 Answers  


How to get second highest salary from a table

3 Answers  


What is mutating table error?

1 Answers  


Categories