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 is cursor ? And what is difference between Trigger ?
 Question Submitted By :: Devesh
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is cursor ? And what is difference between Trigger ?
Answer
# 1
Cursor is an Database object and retrive the rows from 
database row by row ,
And it is maily use for ot reduce the network traffic
it contains 5 features
1.DECLARE the Cursor
2.OPEN the cusrsor
3.FETCH the cursor 
4.CLOSE the cursor
5.DEALLOCATE the cursor

TRIGGER : IT is also an database object and  You can 
perform an anction Trigger will fire automatacallly.
like (DML,DDL)
They can cascade changes through related tables in the 
database; however, these changes can be executed more 
efficiently using cascading referential integrity 
constraints.

They can guard against malicious or incorrect INSERT, 
UPDATE, and DELETE operations and enforce other 
restrictions that are more complex than those defined with 
CHECK constraints. 

Multiple DML triggers of the same type (INSERT, UPDATE, or 
DELETE) on a table allow multiple, different actions to 
take place in response to the same modification statement.
 
Is This Answer Correct ?    19 Yes 3 No
Bhaskar
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
How to retrieve data from log files in SQL SERVER ?????  1
How can your resolve deadlocks? IBM3
What are primary keys and foreign keys?  3
What is Deadlock? Satyam3
How do you check the performance of a query and how do you optimize it?  1
What is de-normalization and when do you do it?  3
How to count the number of duplicate items in a table?  1
Explain Trigger with an example?  1
where do you use Isolations?give me some exmpale?  1
1.what is stored procedure?Its significance with example? 2.Explain about index with syntax and example? plz do reply.........  1
What is normalization?  6
What is the difference between the following two sql statements select count(*) from <tablename> select count(col_name) from <tablename> 247Customer2
Difference between server.transfer and server.execute method?  1
What are the different types of replication? How are they used?  3
wht's the differece between sqlserver05 and sqlserver2000  3
what is syntex second or third highest salary. thanks & Regards Dhirendra sinha  4
what is normalization? what is denormalization? Satyam5
Can you tell me the difference between DELETE & TRUNCATE commands?  11
What is the difference between HAVING clause and the WHERE clause?  4
Which data type can be used only on OUTPUT parameters of the stored proceduer?  2
 
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