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 ... , 13, 14, 15  Next



DB2 INTERVIEW QUESTIONS
SELECT AVG(SALARY) FROM EMP yields inaccurate results. Why?
Question : My SQL statement SELECT AVG(SALARY) FROM EMP yields inaccurate results. Why?

View Answer(1)

Can you use MAX on a CHAR column?
Question : Can you use MAX on a CHAR column?

View Answer(1)

What are aggregate functions?
Question : What are aggregate functions?

View Answer(1)

substring - Get first 5 characters from a db2 field
Question : How do you retrieve the first 5 characters of FIRSTNAME column of DB2 table EMP ?

View Answer(1)

How do you find the maximum value in a column in db2?
Question : How do you find the maximum value in a column in db2?

View Answer(1)

How do you select a row using indexes in DB2?
Question : How do you select a row using indexes in DB2?

View Answer(1)

How do you eliminate duplicate values in DB2 SELECT ?
Question : How do you eliminate duplicate values in DB2 SELECT ?

View Answer(1)

How to find out the total number of rows in a DB2 table?
Question : How would you find out the total number of rows in a DB2 table?

View Answer(4)

Goto page Previous  1, 2, 3 ... , 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