adspace


What is trigger types in sql?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Is primary key clustered index?

1019


how to start mysql server? : Sql dba

1267


what is collation? : Sql dba

1229


what is bcp? When does it used? : Sql dba

1056


what is dbms? : Sql dba

1061


what is schema? : Sql dba

1147


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2091


what are the advantages of sql ? : Sql dba

1142


What is your daily office routine?

2346


what are all the common sql function? : Sql dba

1131


How do I remove duplicates in two columns?

1187


what is sql server agent? : Sql dba

1182


Can we use distinct and group by together?

1133


What is the current version of postgresql?

1178


Can delete statement be rollbacked?

1054