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

DB2 Interview Questions

Questions Answers Views Company eMail

What are the 4 environments which can access DB2 ?

2 7186

What is the picture clause of the null indicator variable?

6 19436

What will the FREE command do to a plan?

2 5952

What is a DB2 bind?

Logica CMG,

1 7393

What information can you find in SYSIBM.SYSLINKS table?

TCS,

1 9390

What is the difference between IN subselects and EXISTS subselect?

HCL, PreVator, TCS,

1 11192

What is meant by concurrency?

1 6270

What is subquery ?

6 12855

How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?

1 5937

How does the processing of a correlated subquery differ from a non correlated subquery?

1 7539

Can you define an Index if the table size less than 10 PAGES?

IBM,

1 6377

What are the various locks available?

CTS,

5 12497

What will the DB2 optimizer do?

2 6425

What are the contents of a DCLGEN?

MetLife,

4 13459

What is deadlock?

2 7284

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is db2 command?

1088

What is load utility in db2?

1227

How do you concatenate the firstname and lastname from emp table to give a complete name?

1115

What is database manager in db2?

1060

How is deadlock resolved?

1195

How to find the maximum value in a column in the db2 database?

1125

When reorg is used?

1178

What are db2 objects?

1085

What is alias in db2?

1108

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

1287

What is the use of with ur in db2?

1108

What are the different types of base tables?

1157

Which command is used to remove all rows from a table?

1173

what is a corelated subquerry?

1166

How to restart a DB2 program?

1953

For More Un-Answered { DB2 } Questions Click Here