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  >>  MainFrame  >>  IBM MainFrame  >>  DB2
 
 


 

 
 COBOL interview questions  COBOL Interview Questions
 JCL interview questions  JCL Interview Questions
 CICS interview questions  CICS Interview Questions
 DB2 interview questions  DB2 Interview Questions
 IMS interview questions  IMS Interview Questions
 IDMS interview questions  IDMS Interview Questions
 Natural interview questions  Natural Interview Questions
 ADABAS interview questions  ADABAS Interview Questions
 REXX interview questions  REXX Interview Questions
 Assembler interview questions  Assembler Interview Questions
 CLIST interview questions  CLIST Interview Questions
 QMF interview questions  QMF Interview Questions
 MVS interview questions  MVS Interview Questions
 OS390 interview questions  OS390 Interview Questions
 OS 2 interview questions  OS 2 Interview Questions
 VSAM interview questions  VSAM Interview Questions
 QSAM interview questions  QSAM Interview Questions
 Sysplex interview questions  Sysplex Interview Questions
 IBM MainFrame AllOther interview questions  IBM MainFrame AllOther Interview Questions
Question 
what is the difference between normal select query and 
currosor
 Question Submitted By :: Pratap
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what is the difference between normal select query and currosor
Answer
# 1		 
Normal select Query fetches all rows in one go while cursor
fetches one row at a time.
 
Is This Answer Correct ?    3 Yes 1 No
Vinay Srivastava
 
  Re: what is the difference between normal select query and currosor
Answer
# 2		 
using select in embedded sql with where clause should fetch
only one row , but cursor can be used when we need more rows
to be retrieved one at a time.

In case more than one row is retrieved in a select clause it
will throw -811 sql error.
 
Is This Answer Correct ?    2 Yes 0 No
Jagan
 
 
 

 
 
 
Other DB2 Interview Questions
 
  Question Asked @ Answers
 
What is isolation level?  1
what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names Accenture4
What is a view? Why use it?  2
AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE Accenture1
What is auditing?  1
What is a cursor?  2
what is the difference between join and union?  2
how to take the back up of the DB2 table.  2
Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?  6
Where is the output of EXPLAIN stored?  2
What is a DB2 bind? Logica-CMG1
What is RUNSTATS?  1
What are the contents of a DCLGEN? MetLife2
What is a DBRM, PLAN ?  1
Can we declare DB2 HOST variable in COBOL COPY book?  2
How can you quickly find out the number of rows updated after an update statement? CSI1
Where besides the DB2 catalog is database object information stored by DB2?  1
What are column-name qualifiers used?  1
Explain the use of the WHERE clause.  2
what is Runstats? Whem will u choose to runatats?  1
 
For more DB2 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