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 5760

What is copy book?

Thomson Reuters,

1 5239

Write a query to retrive partial string.

2 5708

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 8974

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 5597

what is plan? is plan executable or package?

4 11626

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

3 7366

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

2 6329

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

CTS,

5 20175

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

2 8655

how many bytes timestamp token occupies?

Boss Global, Cap Gemini, TCS,

6 15679

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

4 10026

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,

3208

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 12432

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 6760

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is db2 instance?

1094

What are types of indexes?

1072

Which component is responsible for db2 startup and shutdown?

1035

What is with ur in db2?

1316

What is the role of data manager in the db2 database?

1107

What is an instance database?

1052

What is blu acceleration in db2?

1069

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

9200

Why select is not preferred in embedded sql programs?

1299

What is null value in db2?

1024

Define buffer pool.

1054

What is alias in db2?

1060

What is the picture clause of null indicator variable?

1138

what is the role of the cursor in db2?

1067

What is a storage group (stogroup)?

1246

For More Un-Answered { DB2 } Questions Click Here