DB2 Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

DB2 Interview Questions

Questions Answers Views Company eMail

What is dbrm? When it will be created?

1084

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1141

What is dbrm? What it contains?

1211

What does sqlcabc has?

1096

What is the difference between cursor stability and repeatable read isolation levels?

1235

How to execute stored procedures?

1175

What is sqlca?

1128

Are view updateable?

1089

How and when does the db2 enforces the unique key?

1140

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

1232

What is dbrm? What it contains? When it will be created?

1099

What is the difference between spufi and qmf?

1200

What is the max length of sqlca?

1267

What are the bind parameters ibm db2?

1098

what are bind concepts in db2 cobol?

1137

Post New DB2 Questions

Un-Answered Questions { DB2 }

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

1154

What is sqlca’s maximum length?

1246

Explain about rct.

1130

What are the bind parameters ibm db2?

1098

Why select is not preferred in embedded sql programs?

1346

Explain about mirror activator disk mirroring?

1059

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

1082

What is a buffer in memory?

1107

Discuss about db2 bind?

1152

How many databases are there?

1106

What is package in db2 mainframe?

1033

Which command is used to connect to a database in DB2 ? Give the Syntax.

1148

What are the contents of a dclmgen?

1176

What is the information associated with sysibm.syslinks table?

1166

Differentiate between cs and rr isolation levels? Where do you specify them?

1115

For More Un-Answered { DB2 } Questions Click Here