DB2 Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

DB2 Interview Questions

Questions Answers Views Company eMail

What is Declaration Generator(DCLGEN)?

1 7193

What is the difference between static and dynamic SQL?

1 25805

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

IBM,

1 7687

What is RUNSTATS?

3 7806

How many sub queries can you combine together ?

IBM,

4 10406

What is a cursor and what is its function?

2 5663

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 5034

What does the sqlcode of -818 pertain to?

3 7585

How many clustering indexes can be defined for a table?

2 7100

What is tablespace?

3 6661

What is the function of the Data Manager?

2 5201

What is a SELECT statement?

1 4413

How do you define a correlated name?

1 3986

What is the self-referencing constraint?

2 6350

What is a buffer pool?

2 6474

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is collection in db2 bind?

1017

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

1170

List down the data types in the db2 database.

1124

What is dbrm library?

1055

What are catalog tables in db2?

1050

What is dbrm?

1105

List out the data types available.

1153

What is the difference between using bind () and rebind () methods of naming class?

1401

What is a trigger in the db2 database?

1080

How do I create a view in db2?

1024

How to get the ddl of a table in db2?

1131

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

1536

When reorg is used?

1129

How does a cursor work?

988

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

2248

For More Un-Answered { DB2 } Questions Click Here