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 7055

What is the difference between static and dynamic SQL?

1 25698

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

IBM,

1 7589

What is RUNSTATS?

3 7640

How many sub queries can you combine together ?

IBM,

4 10146

What is a cursor and what is its function?

2 5523

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 4923

What does the sqlcode of -818 pertain to?

3 7418

How many clustering indexes can be defined for a table?

2 6951

What is tablespace?

3 6506

What is the function of the Data Manager?

2 5070

What is a SELECT statement?

1 4288

How do you define a correlated name?

1 3910

What is the self-referencing constraint?

2 6214

What is a buffer pool?

2 6365

Post New DB2 Questions

Un-Answered Questions { DB2 }

can we view the access paths created by dbrm ? how ? thx

6979

How many databases are there?

992

Mention the different locking levels that are available in db2.

1073

What is performance tuning db2?

1010

What is runstats db2?

967

What is package in cobol db2?

1078

How to connect to db2 database from windows command line?

1003

Mention the downsides of page level lock.

1112

Can we insert update delete in view?

912

What is buffer pool in the db2 database?

1047

Is ibm db2 open source?

1016

What is database alias db2?

1067

Is it possible using max on a char column?

1086

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

961

What is the maximum No of rows per page?

1013

For More Un-Answered { DB2 } Questions Click Here