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 3766

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

RBS,

1 2736

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

1693

What's The Percentage Free Space ?

IBM,

1282

What's The Error Code For Unique Index Voilation?

IBM,

1299

What is a Foreign Key?

Tavant Technologies, Zensar,

1139

what is a corelated subquerry?

IBM,

1166

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

IBM,

1220

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

IBM,

1342

B37 abend during spufi?

IBM,

1506

What is the maximum No of rows per page?

IBM,

1109

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

IBM,

1166

How to rename a table in DB2 ?

MCN Solutions,

1145

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

MCN Solutions,

1147

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

MCN Solutions,

1591

Post New DB2 Questions

Un-Answered Questions { DB2 }

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2261

Is db2 a mainframe?

1093

What is the physical storage length of time data type?

1175

what are bind concepts in db2 cobol?

1137

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

2111

How is the value function used?

1204

What's The Percentage Free Space ?

1282

How to get the ddl of a table in db2?

1168

What is the physical storage length of date data type?

1304

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

1156

What is universal database?

1118

How many databases can be created inside an instance in db2 ?

1084

What is reorg?

1238

What is access path in db2?

1042

What do you mean by storage group (stogroup)?

1079

For More Un-Answered { DB2 } Questions Click Here