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 6105

What is the database descriptor?

2 14648

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

1 9759

What is meant by AUTO COMMIT?

3 10158

What information is contained in a SYSCOPY entry?

2 10004

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

Emsang,

5 20538

What is lock contention?

1 5632

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 4502

What is COPY PENDING status?

6 36979

What is IMAGECOPY ?

6 39677

What are the functions of Bind?

Amdocs, IBM,

2 8573

What is a cursor?

2 6547

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

1 13730

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

2 5591

What can the Locate option of the Repair Utility accomplish?

2 5633

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is load utility in db2?

1179

What is the role of schema in the db2 database?

1269

List some fields from sqlca?

1056

Which command is used to remove all rows from a table?

1106

What is cursor in dbms?

1060

What is a cursor in programming?

1063

What is a db2 schema?

1223

How do we specify index to include or not during bind process.

2126

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

1036

What is runstats db2?

1017

Is db2 a mainframe database?

996

How do I add a column in db2?

1046

What is db2 connect?

1064

Explain what are the various isolation levels possible?

1041

Explain about mirror activator disk mirroring?

1004

For More Un-Answered { DB2 } Questions Click Here