DB2 INTERVIEW QUESTIONS


Home Forum Online Tutorials Interview Questions Mainframe Books IT News

Home > Discussion Forum > DB2 INTERVIEW QUESTIONS

DB2 INTERVIEW QUESTIONS

No of Questions : 117

Goto page Previous 1, 2, 3 ... , 10, 11, 12 Next

DB2 INTERVIEW QUESTIONS

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)

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)

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

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