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 5210

What is the database descriptor?

2 13037

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

1 8563

What is meant by AUTO COMMIT?

3 8860

What information is contained in a SYSCOPY entry?

2 8915

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

Emsang,

5 18746

What is lock contention?

1 4759

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 3779

What is COPY PENDING status?

6 34750

What is IMAGECOPY ?

6 37091

What are the functions of Bind?

Amdocs, IBM,

2 7184

What is a cursor?

2 5571

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

1 12515

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

2 4280

What can the Locate option of the Repair Utility accomplish?

2 4669


Post New DB2 Questions

Un-Answered Questions { DB2 }

What is load utility in db2?

665


What is node in db2?

606


What is dbrm? What it contains?

678


Give the name of some fields form sqlca.

609


What is syscat in db2?

574






Which isolation level provides maximum concurrency?

660


What do you mean by storage group (stogroup)?

580


Which component is used to execute the sql statements?

617


How can deadlocks be resolved?

538


What are the various isolation levels possible?

645


What is a db2 collection?

603


How to restart a DB2 program?

1356


What is lock escalation in db2?

572


On which levels locks can be applied?

653


What is the latest version of ibm db2?

735