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                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
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 
There is a trigger defined for INSERT operations on a 
table, in an OLTP system. The trigger is written to 
instantiate a COM object and pass the newly insterted rows 
to it for some custom processing. What do you think of this 
implementation? Can this be implemented better?
 Question Submitted By :: Swapna
I also faced this Question!!     Rank Answer Posted By  
 
  Re: There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
Answer
# 1		 
Instantiating COM objects is a time consuming process and 
since you are doing it from within a trigger, it slows down 
the data insertion process. Same is the case with sending 
emails from triggers. 

This scenario can be better implemented by logging all the 
necessary data into a separate table, and have a job which 
periodically checks this table and does the needful.
 
Is This Answer Correct ?    0 Yes 0 No
Swapna
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
how to know Who Is Blocking Your SQL Server?  3
how to get the rowid/rownumbes of a table in sqlserver IBM5
WRITE A FUNCTION TO DISPLAY THE OUTPUT OF AN EXISTING TABLE RANGE LIKE COMMAM SEPERATED VALUES LIKE RANGE1,RANGE2,... TVS2
How do you read transaction logs  1
when inserting to a table how many rows will be effected using triggers  1
How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables? TCS3
Whether the updations made to the views reflect the original records in the table NIIT5
write query for fourth maximum salary from employee table Mind-Tree5
What is database replicaion? What are the different types of replication you can set up in SQL Server? HCL4
how to dispaly a particular row details from a given table  1
How to perfor If the table running time is taking 2hours and table is having 10 rows in it?  1
how to get the automatic backup of the database in the sql server  3
What is a materialized view?  2
What's the purpose of Stored Procedure? Wipro4
Explain DBMS, RDBMS?  4
Which virtual table does a trigger use? TCS6
Why we need a group by clause?  3
is there more the two primary key in a single table? Systematix22
What is a transaction and what are ACID properties? IBM4
there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query that will result a horizontal output A,B,C vsworx7
 
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