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 7279

What is the difference between static and dynamic SQL?

1 25878

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

IBM,

1 7755

What is RUNSTATS?

3 7909

How many sub queries can you combine together ?

IBM,

4 10573

What is a cursor and what is its function?

2 5764

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 5102

What does the sqlcode of -818 pertain to?

3 7693

How many clustering indexes can be defined for a table?

2 7204

What is tablespace?

3 6771

What is the function of the Data Manager?

2 5298

What is a SELECT statement?

1 4478

How do you define a correlated name?

1 4062

What is the self-referencing constraint?

2 6441

What is a buffer pool?

2 6574

Post New DB2 Questions

Un-Answered Questions { DB2 }

Define predicate?

1200

What is db2? Explain.

1107

What is ibm db2 connect?

1050

What is the use of value function?

1203

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2261

What is bind and rebind in db2?

1186

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

1692

What are the rules for db2 programming?

1152

How do I import data from excel to db2?

1127

What is runstats and reorg in db2?

1355

Explain in brief how does db2 determine what lock-size to use?

1085

Differentiate between cs and rr isolation levels? Where do you specify them?

1115

What is blu acceleration in db2?

1123

What is dbrm in db2 database?

1187

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1156

For More Un-Answered { DB2 } Questions Click Here