CrowdforGeeks | Build Skills with Online Courses from Top Institutions

Top 100+ Trigger Interview Questions And Answers

Question 1. Explain Trigger And Trigger Types?

Answer :

A cause is a unique kind of a shop method that executes in reaction to certain movement carried out on the table like insertion, deletion or updating of statistics

Basically there are logical types:

DDL triggers
DML triggers
DDL triggers you can categorize:

Transact-SQL DDL Trigger
CLR DDL Trigger
DML trigger kinds are:

INSTEAD OF DML trigger
AFTER DML cause
There is one unique kind trigger called logon cause in square server.

Question 2. What Are Ddl Triggers And Types Of Ddl Trigger?

Answer :

DDL triggers hearth in response to an occasion taking place on the server. However, DDL triggers do now not fire in response to UPDATE, INSERT, or DELETE (DML) statements on a table or view. Instead, they fireplace in reaction to Data Definition Language (DDL) statements that begin with the keywords CREATE, ALTER, and DROP.

DDL triggers you could categorize:

Transact-SQL DDL Trigger
CLR DDL Trigger
PL/SQL Interview Questions
Question 3. What Are Dml Triggers And Types Of Dml Triggers?

Answer :

DDL triggers fire in reaction to UPDATE, INSERT, or DELETE (DML) statements on a table or view.

DML trigger sorts are:

INSTEAD OF DML cause
AFTER DML cause
Question four. What Is Transact-sq. Ddl Trigger?

Answer :

A special kind of Transact-SQL stored process that executes one or extra Transact-SQL statements in response to a server-scoped or database-scoped event. For example, a DDL Trigger may additionally fire if a assertion which includes ALTER SERVER CONFIGURATION is completed or if a desk is deleted by using the use of DROP TABLE.

SQL Server 2008 Tutorial
Question 5. What Is Clr Ddl Trigger?

Answer :

Instead of executing a Transact-SQL stored method, a CLR trigger executes one or more methods written in controlled code which can be members of an assembly created inside the .NET Framework and uploaded in SQL Server.

Example:

CREATE TRIGGER safety

ON DATABASE

FOR DROP_TABLE, ALTER_TABLE

PRINT 'You ought to disable Trigger "safety" to drop or

adjust tables!'

ROLLBACK;

SQL Server 2008 Interview Questions
Question 6. What Is After Dml Trigger?

Answer :

AFTER triggers are finished after the motion of the INSERT, UPDATE, MERGE, or DELETE statement is finished correctly.

Question 7. What Is Instead Of Dml Trigger?

Answer :

DML trigger is carried out rather than the triggering SQL statement, therefore, overriding the actions of the triggering statements. Therefore, they can be used to perform mistakes or value checking on one or greater columns and the carry out additional moves earlier than insert, updating or deleting the row or rows.

SQL Database Tutorial SQL Database Interview Questions
Question eight. What Is Logon Trigger?

Answer :

Special form of cause fire when LOGON occasion of Sql Server is raised is called lo logon cause. You can use this cause to audit Sql server activities, control server periods, inclusive of to music login interest or restriction the wide variety of classes for a selected login.

Question nine. Why The Trigger Fires Multiple Times In Single Login?

Answer :

Reason multiple SQL Server services are strolling in addition to intelligence is turned on.

PostgreSQL Interview Questions
Question 10. It Is Possible To Create Trigger On Views?

Answer :

Yes, most effective Instead Of cause.

Apex Tutorial
Question 11. How Many Triggers Are Possible Per Table?

Answer :

One Instead Of Trigger and any After Triggers.

SQL DBA Interview Questions
Question 12. When Multiple After Triggers Are Attached To Sql Table, How To Control The Order Of Execution?

Answer :

Using sp_settriggerorder technique.