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 7189

What is the difference between static and dynamic SQL?

1 25804

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

IBM,

1 7685

What is RUNSTATS?

3 7805

How many sub queries can you combine together ?

IBM,

4 10401

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 5032

What does the sqlcode of -818 pertain to?

3 7582

How many clustering indexes can be defined for a table?

2 7099

What is tablespace?

3 6657

What is the function of the Data Manager?

2 5199

What is a SELECT statement?

1 4412

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 }

When do you specify the isolation level?

1030

Give the name of some fields form sqlca.

1077

Why do chiropractors use drop table?

1107

Explain about rct in db2?

1109

Why do we need reorg in db2?

986

What is a buffer in memory?

1058

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

Explain about mirror activator disk mirroring?

1009

Define buffer pool.

1054

Why cursor is used in db2?

1036

Explain what are the various isolation levels possible?

1044

What r the comman abends in db2, jcl and cobol???????

2253

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1194

Explain the contents that are a part of dclgen.

1091

Which is faster delete or truncate?

1127

For More Un-Answered { DB2 } Questions Click Here