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 6116

What is the database descriptor?

2 14666

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

1 9769

What is meant by AUTO COMMIT?

3 10166

What information is contained in a SYSCOPY entry?

2 10011

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

Emsang,

5 20551

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 4505

What is COPY PENDING status?

6 36999

What is IMAGECOPY ?

6 39697

What are the functions of Bind?

Amdocs, IBM,

2 8581

What is a cursor?

2 6558

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 5599

What can the Locate option of the Repair Utility accomplish?

2 5642

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is innodb buffer pool?

1053

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2852

Explain about rct in db2?

1109

What is dbrm in db2 database?

1116

What is a Foreign Key?

1095

What is scrollable cursor in db2?

1055

Explain about rct.

1087

What are the 2 sqlcodes that are returned?

1189

Describe major components of db2?

1092

What is view db2?

1076

Are view updateable?

1043

What is precompiler in db2?

1018

What is db2 plan table?

1049

What happens in bind step in a db2 program?

971

Is db2 a mainframe?

1043

For More Un-Answered { DB2 } Questions Click Here