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

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 6182

What is the database descriptor?

2 14791

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

1 9879

What is meant by AUTO COMMIT?

3 10287

What information is contained in a SYSCOPY entry?

2 10099

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

Emsang,

5 20711

What is lock contention?

1 5717

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 4584

What is COPY PENDING status?

6 37198

What is IMAGECOPY ?

6 39896

What are the functions of Bind?

Amdocs, IBM,

2 8697

What is a cursor?

2 6652

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

1 13841

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

2 5691

What can the Locate option of the Repair Utility accomplish?

2 5743

Post New DB2 Questions

Un-Answered Questions { DB2 }

Define predicate?

1199

On which levels locks can be applied?

1200

Which components manage deadlocks in db2?

1117

What is an instance database?

1095

How do I add a column to an existing table in db2?

1080

What is dbrm in db2 database?

1187

How to restart a DB2 program?

1953

Can you tell me how can you find out the # of rows updated after an update statement?

1144

Can one database have multiple instances?

1093

What is the difference between oracle and db2?

1167

Explain about open switch business continuity software?

1180

What is commit in db2?

1100

What is copy pending and check pending in db2?

1038

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

1154

What is buffer pool and list some of them?

1090

For More Un-Answered { DB2 } Questions Click Here