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



DB2 INTERVIEW QUESTIONS
meaning of underscore in the LIKE statement?
Question : What is the meaning of underscore ( ?_? ) in the LIKE statement?

View Answer(1)

When do you use a LIKE statement?
Question : When do you use a LIKE statement?

View Answer(1)

What is 'LIKE' used for in WHERE clause?
Question : What is 'LIKE' used for in WHERE clause? What are the wildcard characters?

View Answer(1)

Is BETWEEN inclusive of the range values specified?
Question : Is BETWEEN inclusive of the range values specified?

View Answer(1)

In the WHERE clause what is BETWEEN and IN?
Question : In the WHERE clause what is BETWEEN and IN?

View Answer(1)

What is the restriction on using UNION in embedded SQL?
Question : What is the restriction on using UNION in embedded SQL?

View Answer(1)

UNION UNION ALL using in combined sql
Question : Suppose I have five SQL SELECT statements connected by UNION/UNION ALL, how many times should I specify UNION to eliminate the duplicate rows?

View Answer(1)

What is UNION,UNION ALL?
Question : What is UNION,UNION ALL?

View Answer(1)

What is the use of VALUE function?
Question : What is the use of VALUE function?

View Answer(1)

Concatenate two fields in DB2 SQL
Question : How do you concatenate the FIRSTNAME and LASTNAME from EMP table to give a complete name?

View Answer(1)

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