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 8900

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

1 5737

What is the difference between group by and order by?

IBM, TCS,

2 14622

How many buffer pools are there in DB2?

2 7413

What are the three lock types?

2 6542

When is the access path determined for dynamic SQL?

2 9121

What is a Database Request Module(DBRM)?

4 20192

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

Tech Mahindra,

3 14318

What is cursor stability?

1 8438

What are data types?

2 5392

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

2 9640

What are leaf pages?

3 8827

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

IBM,

3 10507

What are the disadvantages of PAGE level lock?

3 8355

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

1 5319

Post New DB2 Questions

Un-Answered Questions { DB2 }

What does reorg do in db2?

1026

What is explain plan in db2?

989

What is scrollable cursor in db2?

1055

Explain dclgen.

1197

What is the use of dclgen in db2?

1083

What is the difference between plan and package in db2?

1107

How to execute stored procedures?

1130

What does a deadlock mean in DB2?

1160

Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

2363

What is a plan and package in db2?

1097

Why select is not preferred in embedded sql programs?

1299

Is db2 relational database?

973

Can we insert update delete in view?

967

Which component is responsible for processing sql statements and selecting access paths?

1127

Where do you specify them?

1271

For More Un-Answered { DB2 } Questions Click Here