DB2 Interview Questions
Questions Answers Views Company eMail

What does CURRENTDATA option in bind indicate

IBM,

1 8318

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

1 5129

What is the difference between group by and order by?

IBM, TCS,

2 13697

How many buffer pools are there in DB2?

2 6664

What are the three lock types?

2 5727

When is the access path determined for dynamic SQL?

2 8172

What is a Database Request Module(DBRM)?

4 18851

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

Tech Mahindra,

3 12701

What is cursor stability?

1 7905

What are data types?

2 4548

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

2 8473

What are leaf pages?

3 7735

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

IBM,

3 9475

What are the disadvantages of PAGE level lock?

3 7330

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

1 4666


Post New DB2 Questions

Un-Answered Questions { DB2 }

Can you use max on a char column?

717


What is table space in db2?

663


What is the difference between bind and rebind in db2?

1003


Explain the benefits you can get from mainframe connect?

612


How to check table size in db2 sap?

667






What are union and union all?

623


What is page size in db2?

638


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

669


How do I optimize a query in db2?

710


What is buffer pool?

728


If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

1668


How would you find out the total number of rows in a db2 table?

664


What is reorg?

691


What is db2 purescale?

644


How to execute stored procedure in db2 command editor?

630