What is a "trigger"? - Trigger is a named PL/SQL block which is executed automaticaly when certain DML actions like INSERT,UPDATE, DELETE etc takes place in the table for which trigger is written. - SQL Server Interview Questions and Answers

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

DATABASE

SQL SERVER

DETAILS

Question: What is a "trigger"?

Answer: Trigger is a named PL/SQL block which is executed automaticaly when certain DML actions like INSERT,UPDATE, DELETE etc takes place in the table for which trigger is written.

Category	SQL Server Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.3) By 8595 users
Added on	7/25/2011
Views	70925
Rate it!

Question: What is a "trigger"?

Answer:

Trigger is a named PL/SQL block which is executed automaticaly when certain DML actions like INSERT,UPDATE, DELETE etc takes place in the table for which trigger is written. Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	Why can a "group by" or "order by" clause be expensive to process?	- SQL Server Interview Questions & Answers"> View Answer
	What are "HINTS"? What is "index covering" of a query?	query? - SQL Server Interview Questions & Answers"> View Answer
	What is a VIEW? How to get script for a view?	View Answer
	What is SQL*Loader?	View Answer
	Difference between "VARCHAR" and "VARCHAR2" datatypes.	- SQL Server Interview Questions & Answers"> View Answer
	What is the difference among "dropping a table”,” truncating a table" and deleting all records" from a table.	View Answer
	Difference between "ORACLE" and "MICROSOFT ACCESS" databases.	- SQL Server Interview Questions & Answers"> View Answer
	How to create a database link?	View Answer
	What's the use of SQL Profiler?	View Answer
	What is the use of database index (apart from fast searching of records);What is use of composite key ?	View Answer
	What is SQL*Loader? Difference between	View Answer
	What is the maximum value that can be stored for a datetime field?	View Answer
	How to find out duplicate records in sql server.	View Answer
	How many column maximum we can add in one table and how many foreign key maximum we can use in one table	View Answer
	What is the code to create a table having a column named DATE, which takes date in the format dd/mm/yyyy, in SQL Server2000? Or any format of date.	View Answer
	Can we generate a trigger for two tables? if so what is the query to generate a trigger for two tables employye table and department table with employee having department no.	View Answer
	Write sql query for retrieving employee names from employee table who are having salary greater than 5000 without using where clause	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All SQL Server Interview Questions & Answers - Exam Mode / Learning Mode