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 7080

What is the picture clause of the null indicator variable?

6 19251

What will the FREE command do to a plan?

2 5840

What is a DB2 bind?

Logica CMG,

1 7304

What information can you find in SYSIBM.SYSLINKS table?

TCS,

1 9296

What is the difference between IN subselects and EXISTS subselect?

HCL, PreVator, TCS,

1 11092

What is meant by concurrency?

1 6175

What is subquery ?

6 12653

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

1 5866

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

1 7462

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

IBM,

1 6310

What are the various locks available?

CTS,

5 12323

What will the DB2 optimizer do?

2 6335

What are the contents of a DCLGEN?

MetLife,

4 13295

What is deadlock?

2 7146

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is null indicator in cobol db2?

1067

What is check constraint in db2?

1090

What is the use of dclgen in db2?

1085

What is a db2 table?

1017

How to find the number of rows in db2 tables?

1073

Give the name of some fields form sqlca.

1081

What is an instance in db2?

1034

What is table space in db2?

1019

My sql statement select avg(salary) from emp yields inaccurate results. Why?

1095

Is db2 a database?

972

Before you give the explain statement, what are the prerogatives?

1040

What are the two types of logging in the db2 database? Explain them.

1074

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

1111

How to check sequence on a table in db2?

1062

What are iseries servers?

1075

For More Un-Answered { DB2 } Questions Click Here