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 6114

What is the database descriptor?

2 14666

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

1 9767

What is meant by AUTO COMMIT?

3 10162

What information is contained in a SYSCOPY entry?

2 10010

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

Emsang,

5 20547

What is lock contention?

1 5636

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 4504

What is COPY PENDING status?

6 36994

What is IMAGECOPY ?

6 39686

What are the functions of Bind?

Amdocs, IBM,

2 8580

What is a cursor?

2 6554

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

1 13738

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

2 5596

What can the Locate option of the Repair Utility accomplish?

2 5641

Post New DB2 Questions

Un-Answered Questions { DB2 }

Are views updateable?

1153

List out the buffer pools in db2

1073

How to check last update on table in db2?

1059

What is db2 instance?

1094

What are union and union all?

981

What is dpf in db2?

1109

Why do we need reorg in db2?

985

Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

1436

What are catalog tables in db2?

1048

Can you use max on a char column?

1097

Name the various locking levels available?

1091

What is the use of predicate?

1041

How do you concatenate the firstname and lastname from emp table to give a complete name?

1075

How can you classify the locks in db2?

1089

What is buffer pool and list some of them?

1028

For More Un-Answered { DB2 } Questions Click Here