DB2 Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

DB2 Interview Questions

Questions Answers Views Company eMail

What is rct?

824

What is check constraint in db2?

680

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

690

Which components manage deadlocks in db2?

683

What is the physical storage length of time data type?

736

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

667

What is the picture clause of null indicator variable?

752

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

654

What is concurrency in db2?

1 1527

Which component is responsible for db2 startup and shutdown?

690

What is data manager?

672

What is the physical storage length of date data type?

809

Which isolation level provides highest data integrity?

655

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

677

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

698

Post New DB2 Questions

Un-Answered Questions { DB2 }

Can you use max on a char column?

690

What is db2 purescale?

620

What is bind in db2?

652

What is a cursor in programming?

668

What is the difference between dbm cfg and db cfg file in db2 ?

1078

Which component is responsible for processing sql statements and selecting access paths?

735

What is the usage of open cursor command?

665

What is the use of db2 optimizer?

673

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

2825

What is host variable in db2 cobol?

680

Why do we need reorg in db2?

622

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

677

What is package in cobol db2?

754

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

1785

what is a corelated subquerry?

716

For More Un-Answered { DB2 } Questions Click Here