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 6125

What is the database descriptor?

2 14677

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

1 9782

What is meant by AUTO COMMIT?

3 10185

What information is contained in a SYSCOPY entry?

2 10021

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

Emsang,

5 20573

What is lock contention?

1 5647

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 4517

What is COPY PENDING status?

6 37021

What is IMAGECOPY ?

6 39717

What are the functions of Bind?

Amdocs, IBM,

2 8592

What is a cursor?

2 6569

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

1 13750

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

2 5609

What can the Locate option of the Repair Utility accomplish?

2 5645

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is the advantage in De-normalizing tables in DB2?

1184

What is the cobol picture clause of the db2 data types date, time, timestamp?

1069

What is null in db2?

1031

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

2249

Why do we need reorg in db2?

994

What are the bind parameters ibm db2?

1058

Explain packages.

1116

What is the picture clause of null indicator variable?

1138

What is the information associated with sysibm.syslinks table?

1130

What is syscat in db2?

1020

How do you stop a db2 database in linux?

1020

What are iseries servers?

1081

Define db2 and its databases?

1059

What is the use of commit in db2?

1084

What is dpf in db2?

1115

For More Un-Answered { DB2 } Questions Click Here