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 
what is the cursor life span?
 Question Submitted By :: Dinesh Gupta
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what is the cursor life span?
Answer
# 1		 
when curser starts and that is curser life span
 
Is This Answer Correct ?    0 Yes 3 No
Neeraj
 
  Re: what is the cursor life span?
Answer
# 2		 
hi neeraj,
this is not the answer.
answer about the life span of curser.
 
Is This Answer Correct ?    1 Yes 0 No
Gunjan Sapra
 
 
 
  Re: what is the cursor life span?
Answer
# 3		 
hi friends this is answer as per me,

when  static cursor  used  the cursor lifespan is within 
the program only(pl/sql program).its life end when it comes 
outside the program
   when dynamic cursor is used the cursor is accessable by 
outside other programs with in same connection ,not another 
connection.i.e its  lifespan is with in connection
 
Is This Answer Correct ?    4 Yes 1 No
Nageswara Rao.g
 
  Re: what is the cursor life span?
Answer
# 4		 
The Life Span of the Cursor is till the runtime of the 
stored procedure/function in sql server 2005
 
Is This Answer Correct ?    0 Yes 1 No
Sumit
 
  Re: what is the cursor life span?
Answer
# 5		 
The Life Span of the Cursor is till the runtime of the 
stored procedure/function in which the cursor is being used 
in sql server
 
Is This Answer Correct ?    0 Yes 1 No
Sumit
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
any one can explain Self mapping Delegation Remote Credentials  1
What is the Query of getting last 10 transaction Reports (like insert, update, Delete Data from Tabele) ? Wipro4
what is normalization? what is denormalization? Satyam5
Anyone please explain me the concept of Serialization?  3
What is one of the first things you would do to increase performance of a query? For example, a boss tells you that ?a query that ran yesterday took 30 seconds, but today it takes 6 minutes? Wipro1
what is difference between having and where clause ?  2
how to know Who Is Blocking Your SQL Server?  3
What is Query Execution Plan? How does it help optimize or tune a database driven application? Accenture2
What does the INSTEAD OF trigger do?  3
how to delete duplicate rows from table CSC9
Can a stored procedure call itself(recursive). If yes what level and can it be controlled.?  2
what is trigger NIIT1
what is Data Transformation Services (DTS) ?can u explain me in detail? TCS5
to explain sql server 2000 architecture & authentication  1
1.what is stored procedure?Its significance with example? 2.Explain about index with syntax and example? plz do reply.........  1
When do you create cluster and noncluster index? Satyam4
What are the advantages of using views. Why do we need views when we have SPs? 247Customer3
What is the system function to get the current user's user id? TCS3
What is a table called, if it does not have neither Cluster nor Non-cluster Index?  1
how to select a field with firstletter as capital and remaining are small letters  8
 
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