1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category
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

For More Un-Answered { DB2 } Questions Click Here