ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
What does the INSTEAD OF trigger do?
 Question Submitted By :: Renjusha
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What does the INSTEAD OF trigger do?
Answer
# 1
The INSTEAD OF triggers execute instead 
of the original data modification. INSTEAD OF trigger are 
allowed for both tables and views.
 
Is This Answer Correct ?    0 Yes 2 No
S.vanitha
 
  Re: What does the INSTEAD OF trigger do?
Answer
# 2
Instead of triggers are the procedures that execute in 
place of Data Manipulation language (DML)statement on a 
table.

for example, if i have INSTEAD-OF-UPDATE Trigger on 
TableA,and i execute an update statement on that table,the 
code in the INSTEAD-OF-TRIGGER will be executed instead of 
the update statement that I executed.
 
Is This Answer Correct ?    3 Yes 0 No
Vani
 
 
 
  Re: What does the INSTEAD OF trigger do?
Answer
# 3
None of the above answers are correct..

The Main objective of INSTEAD OF TRIGGERS is.. To handling
the complexity of View.,i.e; to manipulating the
non-updateable views(the views that have created by many
tables with help of joins, Group by operators or set operator's)

if u need more .. contact on my mail:

apparao.akki@oracle.com
 
Is This Answer Correct ?    0 Yes 1 No
Apparao Akki
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
what are file groups? Evalueserve3
How to retrieve duplicate rows in a table? How to delete the duplicate entries in a table? Leo-Technologies12
What is a materialized view?  2
How do we return a record set from a Stored Procedure in SQl server 2000?  2
What is the difference between the following two sql statements select count(*) from <tablename> select count(col_name) from <tablename> 247Customer2
How will oyu test the stored procedure taking two parameters namely first name and last name returning full name?  3
how to copy sysdatabase file from c: Drive to D: Drive in SQL Server. IBM4
How can u convert the Date to String? TCS4
What is normalization and what are the different forms of normalizations?  1
How to get the count of distinct records. Please give me the query? Value-Labs5
1.What is the deferece between DBMS & RDBMS? 2.How can you trouble shoot? If u will get error while installing sql server? 3.How can u trouble shoot slow running query? 4.how can u trouble log shipping errors? 5.why do we use merge replication instead of T.log replication? Microsoft4
What is the use of CASCADE CONSTRAINTS?  2
any one can explain Self mapping Delegation Remote Credentials  1
How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode? HCL2
how can we use a composite key for two tables and how can we represent it BoA1
What is the difference between a Application Server and a Database Oracle2
What are the two virtual tables SQL Server maintains for triggers?  2
Explain basic SQL queries with SELECT from where Order By, Group By-Having? Wipro2
What is the purpose of using COLLATE in a query?  1
Please get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)  5
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com