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 is Declaration Generator(DCLGEN)?

1 5880

What is the difference between static and dynamic SQL?

1 24580

How many Buffer pools are there in DB2 and what are they?

IBM,

1 6440

What is RUNSTATS?

3 5841

How many sub queries can you combine together ?

IBM,

4 7737

What is a cursor and what is its function?

2 4021

Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?

1 3801

What does the sqlcode of -818 pertain to?

3 5772

How many clustering indexes can be defined for a table?

2 5342

What is tablespace?

3 4585

What is the function of the Data Manager?

2 3728

What is a SELECT statement?

1 3284

How do you define a correlated name?

1 2988

What is the self-referencing constraint?

2 4906

What is a buffer pool?

2 5098


Post New DB2 Questions

Un-Answered Questions { DB2 }

What is copy pending and check pending in db2?

415


Explain dclgen.

544


Define check constraint.

479


What is the purpose of using commit?

466


How can tablespace be moved to another dasd volume that is allocated for that tablespace?

544






What is bind package and plan in db2?

422


What is the syntax for seeing the columns and data types of a table in the db2 database?

428


How is deadlock resolved?

483


Give the name of some fields form sqlca.

465


What is the use of value function?

463


What is the difference between spufi and qmf?

489


What are the full forms of spufi and dclgen and why are they used?

475


What is the maximum length of sqlca?

640


What is a page in db2?

433


Which isolation level provides highest data integrity?

440