DB2 Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

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 5975

What is copy book?

Thomson Reuters,

1 5323

Write a query to retrive partial string.

2 5826

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 9166

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 5667

what is plan? is plan executable or package?

4 11784

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

3 7476

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

2 6439

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

CTS,

5 20363

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

2 8734

how many bytes timestamp token occupies?

Boss Global, Cap Gemini, TCS,

6 15868

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

4 10222

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,

3261

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 12563

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 6841

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is temporal table in db2?

1097

Can you tell me how can you find out the # of rows updated after an update statement?

1144

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

1090

What is universal database?

1117

What is dbrm? What it contains?

1211

What is the maximum length of sqlca?

1606

What do you mean by between and in? Is between inclusive of specified range values?

1139

What is db2 command?

1088

Define declaration generator (dclgen).

1170

i want to maintain uniqueness on pdf without make lf??????????

2204

What is the use of dclgen in db2?

1135

Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

1529

What is coalesce in db2?

1179

What is db2? Explain.

1107

How do I delete a table in db2?

1121

For More Un-Answered { DB2 } Questions Click Here