DB2 Interview Questions
Questions Answers Views Company eMail

Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?

1 5203

What is the database descriptor?

2 13022

What is the syntax required for the creation of a cursor?

1 8554

What is meant by AUTO COMMIT?

3 8851

What information is contained in a SYSCOPY entry?

2 8905

What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?

Emsang,

5 18732

What is lock contention?

1 4752

Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?

1 3772

What is COPY PENDING status?

6 34728

What is IMAGECOPY ?

6 37057

What are the functions of Bind?

Amdocs, IBM,

2 7173

What is a cursor?

2 5561

When is the authorization check on DB2 objects done - at BIND time or run time?

1 12506

What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?

2 4273

What can the Locate option of the Repair Utility accomplish?

2 4669


Post New DB2 Questions

Un-Answered Questions { DB2 }

How do I import data from excel to db2?

607


How to find the number of rows in a db2 table?

644


Define declaration generator (dclgen).

660


What is dpf in db2?

660


What are packages in db2?

593






How to find the number of rows in db2 tables?

607


What is meant by union and union all?

577


When reorg is used?

668


List out the three types of page locks that can be held.

681


What is the purpose of using commit?

612


What is ibm db2 used for?

596


What is difference between alias and synonym in db2?

635


What is db2 instance?

588


Can we delete records from view?

554


What is a page in db2?

603