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

What are the 4 environments which can access DB2 ?

2 4998

What is the picture clause of the null indicator variable?

6 15029

What will the FREE command do to a plan?

2 3883

What is a DB2 bind?

Logica CMG,

1 5682

What information can you find in SYSIBM.SYSLINKS table?

TCS,

1 7078

What is the difference between IN subselects and EXISTS subselect?

HCL, PreVator, TCS,

1 8736

What is meant by concurrency?

1 4677

What is subquery ?

6 8660

How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?

1 4344

How does the processing of a correlated subquery differ from a non correlated subquery?

1 5982

Can you define an Index if the table size less than 10 PAGES?

IBM,

1 4699

What are the various locks available?

CTS,

5 8690

What will the DB2 optimizer do?

2 4090

What are the contents of a DCLGEN?

MetLife,

4 9682

What is deadlock?

2 4747


Post New DB2 Questions






Un-Answered Questions { DB2 }

What is the difference between db2 and oracle?

203


What are bind parameters in db2?

208


What is database reorganization?

217


How do I optimize a query in db2?

193


What are the contents of a dclmgen?

242






How would the varchar column remarks defined?

246


What is a cursor in programming?

206


What types of tables are there in the db2 database?

238


Can there be more than one cursor open for any program?

230


How can the duplicate values be eliminated from db2 select?

224


What do you mean by commit and rollback?

197


What is database manager in db2?

195


Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

260


How can you classify the locks in db2?

230


What is innodb buffer pool?

203