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 3593

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

RBS,

1 2599

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

1593

What's The Percentage Free Space ?

IBM,

1165

What's The Error Code For Unique Index Voilation?

IBM,

1158

What is a Foreign Key?

Tavant Technologies, Zensar,

1047

what is a corelated subquerry?

IBM,

1071

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

IBM,

1111

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

IBM,

1220

B37 abend during spufi?

IBM,

1410

What is the maximum No of rows per page?

IBM,

1018

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

IBM,

1076

How to rename a table in DB2 ?

MCN Solutions,

1035

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

MCN Solutions,

1049

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

MCN Solutions,

1482

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is a db2 package?

996

What is the syntax for creating a table in the db2 database?

1062

What is rct?

1178

Define predicate?

1072

When the like statement is used?

1167

What's The Percentage Free Space ?

1165

What is the purpose of rollback and commit?

1096

Give a brief description of db2 isolation levels?

1020

What is cobol db2?

938

What is rebind in db2?

1008

What is the meaning concurrency in the db2 database?

1067

How connect db2 database to datastage?

1193

How is the value function used?

1088

What is ibm db2 database?

956

B37 abend during spufi?

1410

For More Un-Answered { DB2 } Questions Click Here