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 3662

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

RBS,

1 2670

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

1653

What's The Percentage Free Space ?

IBM,

1224

What's The Error Code For Unique Index Voilation?

IBM,

1237

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,

1168

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

IBM,

1283

B37 abend during spufi?

IBM,

1455

What is the maximum No of rows per page?

IBM,

1067

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

IBM,

1120

How to rename a table in DB2 ?

MCN Solutions,

1088

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

MCN Solutions,

1104

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

MCN Solutions,

1534

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is the physical storage length of time data type?

1127

What are the rules for db2 programming?

1087

What are foreign keys in db2?

1103

Explain what are the various isolation levels possible?

1044

Can we insert update delete in view?

972

what is the sqlcode -501

13150

What is the connection string to connect to the DB2 Database ?

1128

Explain db2.

1034

Explain the benefits you can get from mainframe connect?

970

What does sqlcabc has?

1054

What is deadlock in db2?

1068

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

1185

Describe major components of db2?

1091

What is difference between rollback and commit?

1157

Is schema the same as database?

1057

For More Un-Answered { DB2 } Questions Click Here