DB2 Interview Questions
Questions Answers Views Company eMail

What is rct?

744

What is check constraint in db2?

599

How can you count the number of rows from a table tab?

629

Which components manage deadlocks in db2?

602

What is the physical storage length of time data type?

664

How many types of page locks can be held in db2?

586

What is the picture clause of null indicator variable?

687

Where can you declare a cursor in a cobol-db2 program?

599

What is concurrency in db2?

1 1415

Which component is responsible for db2 startup and shutdown?

622

What is data manager?

601

What is the physical storage length of date data type?

722

Which isolation level provides highest data integrity?

589

What is the reason behind not using select * in embedded sql programs?

598

What is the maximum size of varchar data type in db2?

641


Post New DB2 Questions

Un-Answered Questions { DB2 }

How do we specify index to include or not during bind process.

1671


How can you find out the # of rows updated after an update statement?

631


How is a typical db2 batch pgm executed?

634


in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

1619


What happens in bind step in a db2 program?

561






Which component is used to execute the sql statements?

612


What is db2 optimizer?

763


Is ibm db2 free?

571


Mention the location where the output received from explain statement is stored.

627


What is the maximum number of columns in a db2 table?

713


What is role in db2?

612


What is the physical storage length of date data type?

722


What does db2 plan contain?

569


On which levels locks can be applied?

651


What is the use of db2?

581