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

DB2 Interview Questions

Questions Answers Views Company eMail

What does CURRENTDATA option in bind indicate

IBM,

1 8972

What is the format (internal layout) of ?TIMESTAMP??

1 5815

What is the difference between group by and order by?

IBM, TCS,

2 14735

How many buffer pools are there in DB2?

2 7514

What are the three lock types?

2 6654

When is the access path determined for dynamic SQL?

2 9237

What is a Database Request Module(DBRM)?

4 20396

What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?

Tech Mahindra,

3 14465

What is cursor stability?

1 8531

What are data types?

2 5494

What is a NULL value? What are the pros and cons of using NULLS?

2 9761

What are leaf pages?

3 8972

when does the SQL statement gets executed when you use cursor in the application programming ?

IBM,

3 10622

What are the disadvantages of PAGE level lock?

3 8497

In terms of DB2 indexing, what is the root page?

1 5390

Post New DB2 Questions

Un-Answered Questions { DB2 }

How can you quickly find out the # of rows updated after an update statement?

1082

What is table space in db2?

1069

What is the syntax for creating a table in the db2 database?

1144

List out the buffer pools in db2

1128

How do I create a view in db2?

1074

What is schema in db2?

1079

What's The Error Code For Unique Index Voilation?

1299

what is db2 restart?

2213

What does a deadlock mean in DB2?

1215

What is the maximum number of columns in a db2 table?

1342

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1141

What is the function of logging in the db2 database?

1172

What are the various isolation levels possible?

1177

What is cursor with hold option in db2?

1134

What is data manager?

1101

For More Un-Answered { DB2 } Questions Click Here