1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category
DB2 Interview Questions
Questions Answers Views Company eMail

What are the 4 environments which can access DB2 ?

 2 6308

What is the picture clause of the null indicator variable?

 6 17747

What will the FREE command do to a plan?

 2 5023

What is a DB2 bind?

Logica CMG,

1 6599

What information can you find in SYSIBM.SYSLINKS table?

TCS,

1 8527

What is the difference between IN subselects and EXISTS subselect?

HCL, PreVator, TCS,

1 10146

What is meant by concurrency?

 1 5507

What is subquery ?

 6 10872

How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?

 1 5278

How does the processing of a correlated subquery differ from a non correlated subquery?

 1 6789

Can you define an Index if the table size less than 10 PAGES?

IBM,

1 5625

What are the various locks available?

CTS,

5 10780

What will the DB2 optimizer do?

 2 5333

What are the contents of a DCLGEN?

MetLife,

4 11875

What is deadlock?

 2 5929

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is node in db2?

690

What is schema in db2?

665

If I have a view which is a join of two or more tables, can this view be updateable?

795

How do I connect my db2 database to ibm?

671

Mention the definition of cobol in varchar field.

776




What is an instance in db2?

646

What are types of indexes?

675

Explain the function of data manager.

713

Explain packages.

753

What is the physical storage length of timestamp data type?

739

What is multi row fetch in db2?

675

How to find the number of rows in db2 tables?

697

What is the syntax for FETCH in DB2 ?

763

What are the rules for db2 programming?

728

When reorg is used?

761

For More Un-Answered { DB2 } Questions Click Here