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 6046

What is the database descriptor?

2 14498

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

1 9655

What is meant by AUTO COMMIT?

3 10030

What information is contained in a SYSCOPY entry?

2 9918

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

Emsang,

5 20363

What is lock contention?

1 5544

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 4434

What is COPY PENDING status?

6 36761

What is IMAGECOPY ?

6 39464

What are the functions of Bind?

Amdocs, IBM,

2 8442

What is a cursor?

2 6466

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

1 13642

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

2 5498

What can the Locate option of the Repair Utility accomplish?

2 5543

Post New DB2 Questions

Un-Answered Questions { DB2 }

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1064

Which components manage deadlocks in db2?

1030

What is a storage group (stogroup)?

1201

Define sqlca.

1064

What do you mean by commit and rollback?

991

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

1103

Define predicate?

1075

Which isolation level provides highest data integrity?

1057

What is db2 and what is the use of db2 optimizer?

1005

What is commit in db2?

1004

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1129

What is host variable?

1026

How to check table size in db2 sap?

990

What is the difference between db2 and oracle?

1077

What is a page in db2?

991

For More Un-Answered { DB2 } Questions Click Here