Can you have more than one cursor open at any one time in a program ? ? - Yes.

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

MAINFRAME

DB2

DETAILS

Question: Can you have more than one cursor open at any one time in a program ? ?

Answer: Yes.

Category	DB2 Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.2) By 8345 users
Added on	9/8/2014
Views	69518
Rate it!

Question: Can you have more than one cursor open at any one time in a program ? ?

Answer:

Yes. Source: CoolInterview.com

In fact, we can have second cursor open inside another already opened cursor. But this impacts the performance and is not recommended. Source: CoolInterview.com

Answered by: Abhay | Date: 5/22/2010 |

Contact Abhay

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
	Is DECLARE CURSOR executable?	View Answer
	What happens when you say OPEN CURSOR?	View Answer
	How do you specify and use a cursor in a COBOL program? ?	View Answer
	Where would you specify the DECLARE CURSOR statement? ?	View Answer
	How would you retrieve rows from a DB2 table in embedded SQL? ?	View Answer
	What is a cursor? why should it be used?	View Answer
	What are correlated subqueries?	View Answer
	Why SELECT * is not preferred in embedded SQL programs?	View Answer
	What is the result of this query if no rows are selected:	View Answer
	Consider the employee table with column PROJECT nullable. How can you get a list of employees who are not assigned to any project?	View Answer
	What do you accomplish by GROUP BY ... HAVING clause? ?	View Answer
	What is the meaning of underscore ( ?_? ) in the LIKE statement? ?	View Answer
	When do you use a LIKE statement?	View Answer
	What is 'LIKE' used for in WHERE clause? What are the wildcard characters?	View Answer
	Is BETWEEN inclusive of the range values specified? ?	View Answer
	In the WHERE clause what is BETWEEN and IN?	View Answer
	What is the restriction on using UNION in embedded SQL?	View Answer
	What is UNION,UNION ALL?	View Answer
	What is the use of VALUE function?	View Answer
	How do you concatenate the FIRSTNAME and LASTNAME from EMP table to give a complete name?	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 DB2 Interview Questions & Answers - Exam Mode / Learning Mode