Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 1726

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

RBS,

1 1173

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

489

What's The Percentage Free Space ?

IBM,

250

What's The Error Code For Unique Index Voilation?

IBM,

223

What is a Foreign Key?

Tavant Technologies, Zensar,

213

what is a corelated subquerry?

IBM,

221

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

IBM,

216

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

IBM,

231

B37 abend during spufi?

IBM,

274

What is the maximum No of rows per page?

IBM,

223

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

IBM,

223

How to rename a table in DB2 ?

MCN Solutions,

222

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

MCN Solutions,

205

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

MCN Solutions,

220


Post New DB2 Questions






Un-Answered Questions { DB2 }

What is bufferpool in db2?

154


What is the use of commit in db2?

201


How do I connect my db2 database to ibm?

178


What is dbrm? What it contains?

189


What do you mean by storage group (stogroup)?

182






What is lock escalation in db2?

171


What db2 400?

189


Explain the contents that are a part of dclgen.

214


What is buffer pool and list some of them?

199


What is the latest version of ibm db2?

174


What is a db2 table?

152


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

1211


What is the physical storage length of timestamp data type?

193


Define data page.

220


In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

202