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

DB2 Interview Questions

Questions Answers Views Company eMail

How can you find out which query is taking lot of time to execute in cobol-db2 program ?

Danske,

1 3658

Write a query to extract first 5 characters of a name in the column Stud_Name?

RBS,

1 2667

How to fetch the last row from the table in SQL (db2)?

1651

What's The Percentage Free Space ?

IBM,

1224

What's The Error Code For Unique Index Voilation?

IBM,

1233

What is a Foreign Key?

Tavant Technologies, Zensar,

1095

what is a corelated subquerry?

IBM,

1122

can all users have the privilage to use the sql statement select * (dml)?

IBM,

1164

What is the maximum number of columns in a db2 table?

IBM,

1279

B37 abend during spufi?

IBM,

1454

What is the maximum No of rows per page?

IBM,

1065

Which are the db2 tools to protect integrity of the database?

IBM,

1120

How to rename a table in DB2 ?

MCN Solutions,

1086

Is it possible to create an Instance in DB2 using DB2 Control Center ?

MCN Solutions,

1101

What is the difference between dbm cfg and db cfg file in db2 ?

MCN Solutions,

1531

Post New DB2 Questions

Un-Answered Questions { DB2 }

Outputs of explain are with matchcols = 0. What does this signify?

1051

What is the purpose of rollback and commit?

1190

Explain the benefits you can get from mainframe connect?

970

What is the use of predicate?

1039

What is sqlca’s maximum length?

1178

What is a trigger in the db2 database?

1072

What is the max length of sqlca?

1214

What is the difference between nvl and coalesce?

1059

Mention the definition of cobol in varchar field.

1246

If I have a view which is a join of two or more tables, can this view be updateable?

1139

How can the duplicate values be eliminated from db2 select?

1103

Which isolation level provides maximum concurrency?

1150

What is buffer pool?

1099

Explain package in db2 and its advantages?

1212

What is db2 look?

1020

For More Un-Answered { DB2 } Questions Click Here