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 8901

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

1 5742

What is the difference between group by and order by?

IBM, TCS,

2 14629

How many buffer pools are there in DB2?

2 7419

What are the three lock types?

2 6548

When is the access path determined for dynamic SQL?

2 9125

What is a Database Request Module(DBRM)?

4 20212

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

Tech Mahindra,

3 14324

What is cursor stability?

1 8441

What are data types?

2 5403

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

2 9645

What are leaf pages?

3 8840

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

IBM,

3 10521

What are the disadvantages of PAGE level lock?

3 8365

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

1 5325

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is the cobol picture clause of the db2 data types date, time, timestamp?

1067

What is package in cobol db2?

1119

What is view db2?

1076

What is reorg and runstats in db2?

1217

Explain db2.

1034

What are the contents of a dclmgen?

1126

How to find the number of rows in a db2 table?

1120

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 .....

2365

Where do you specify them?

1279

What is db2 connect?

1068

What is alias in db2?

1060

What do you mean by commit and rollback?

1040

What does a deadlock mean in DB2?

1167

What is the difference between bind and rebind in db2?

1450

What is the information associated with sysibm.syslinks table?

1123

For More Un-Answered { DB2 } Questions Click Here