IBM MAINFRAME GURU Forum
  Home      Forum      Online Tutorials      Interview Questions      Mainframe Books      IT News
 


Home  >  Discussion Forum  >  DB2 INTERVIEW QUESTIONS
    

DB2 INTERVIEW QUESTIONS

No of Questions : 142
Goto page Previous  1, 2, 3 ... 11, 12, 13, 14, 15  Next



DB2 INTERVIEW QUESTIONS
How do you specify and use a cursor in a COBOL program?
Question : How do you specify and use a cursor in a COBOL program?

View Answer(1)

Where would you specify the DECLARE CURSOR statement?
Question : Where would you specify the DECLARE CURSOR statement?

View Answer(4)

retrieve rows from a DB2 table in embedded SQL
Question : How would you retrieve rows from a DB2 table in embedded SQL?

View Answer(1)

What is a cursor? why should it be used?
Question : What is a cursor? why should it be used?

View Answer(1)

What are the issues related with correlated subqueries?
Question : What are the issues related with correlated subqueries?

View Answer(1)

What are correlated subqueries?
Question : What are correlated subqueries?

View Answer(1)

Why SELECT * is not preferred in embedded SQL programs?
Question : Why SELECT * is not preferred in embedded SQL programs?

View Answer(1)

SUM function
Question : What is the result of this query if no rows are selected:

SELECT SUM(SALARY)

FROM EMP

WHERE QUAL=?MSC?;


View Answer(3)

NULL value
Question : 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(1)

What do you accomplish by GROUP BY ... HAVING clause?
Question : What do you accomplish by GROUP BY ... HAVING clause?

View Answer(1)

Goto page Previous  1, 2, 3 ... 11, 12, 13, 14, 15  Next

Home  >  Discussion Forum  >  DB2 INTERVIEW QUESTIONS


   

IBM MAINFRAME - COBOL Interview Questions( 59 )

IBM MAINFRAME - DB2 Interview Questions ( 110 )

IBM MAINFRAME - JCL Interview Questions( 52 )

IBM MAINFRAME - CICS Interview Questions( 70 )

IBM MAINFRAME - VSAM Interview Questions( 22 )





Google
 
Web mainframegurukul.com









 
Online ABEND Reference ||  JCL References ||  COBOL References ||  VSAM References ||  Tutorials by Drona Series ||  SQL tutorial ||  BOOKS  ||  SiteMap    || Simple JCL Tutorials  || JCL Tutorial from MainframeGurukul.com   || Simple JCL Tutorial - Chapter1   ||  DB2 Interview questions   || JCL Interview Questions   || COBOL Interview Questions   || VSAM Interview Questions   || CICS Interview Questions   || < simple DB2 SQL tutorial



Drona Educational Forums - Mainframe Cobol DB2 CICS Board
Copyright ? 2005 mainframegurukul.com. All rights reserved