Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

DB2 Interview Questions
Questions Answers Views Company eMail

select * from orders where odate between '2010-01-01'and '2010-03-31' How do u fetch this into cursor?

2 3770

What is copy book?

Thomson Reuters,

1 3837

Write a query to retrive partial string.

2 3900

what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)

IBM,

4 5887

how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example

CTS,

1 4020

what is plan? is plan executable or package?

4 7877

if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)

3 4908

For Read Stability locks are not applicable for phantoms, What is Phantoms?

2 4686

In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.

CTS,

5 15380

can any one give the list of some important sql abend codes which r frequently asked in interviews?

2 6731

how many bytes timestamp token occupies?

Boss Global, Cap Gemini, TCS,

6 11559

why we go for SPUFI for creating tables or for sql queries?

4 6620

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

ITC Infotech, Syntel,

2263

what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.

Syntel,

2 9986

OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.

Syntel,

1 5209


Post New DB2 Questions






Un-Answered Questions { DB2 }

What does a deadlock mean in DB2?

235


What is dpf in db2?

208


What is page size in db2?

213


How do I copy a table in db2?

195


What are foreign keys in db2?

234






How can the firstname and the lastname from the emp table be concatenated to generate complete names?

201


How is a typical db2 batch pgm executed?

240


How do you pull up a query which was previously saved in qmf?

232


What's The Error Code For Unique Index Voilation?

270


What parameters are used to control the free space in DB2?

242


What is db2 plan table?

219


What is bind plan?

218


How does cobol compile db2 program?

197


How to get the ddl of a table in db2?

213


What is a buffer in memory?

206