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

DB2 Interview Questions

Questions Answers Views Company eMail

What is a Resource Control Table(RCT)? Describe its characteristics.

3 13552

How is the SUBSTR keyword used in sql?

1 9345

What is an inner join, and an outer join ?

CTA,

1 12938

Where is the access path logic created by the DB2 Optimizer stored?

1 8367

What is a root page?

1 4348

What happens to the PLAN if index used by it is dropped?

1 5764

What keyword does an SQL SELECT statement use for a string search?

2 8240

Which catalog table stores referential constraints?

1 5966

Give the COBOL definition of a VARCHAR field.

2 16887

EXPLAIN has output with MATCHCOLS = 0. What does it mean?

2 11164

How to see the structure of db2 table??

IBM,

4 33066

what is the maximum number of tables that can be joined ?

IBM, TCS,

8 20685

What is normalization and what are the five normal forms?

1 5143

What are simple, segmented and partitioned table spaces ?

TCS,

1 13739

What is dynamic SQL?

ADP,

1 6875

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is a bind card?

1216

What is the purpose of using commit?

1099

Mention the different locking levels that are available in db2.

1136

How to find schema of a table in db2?

1016

What is db2 connect?

1070

What is the maximum size of varchar data type in db2?

1135

How to create db2 table in mainframe?

1154

Why do chiropractors use drop table?

1109

What is a page in db2?

1027

Is db2 a mainframe database?

1000

What is iseries database?

1048

What is a db2 schema?

1233

Which is faster delete or truncate?

1127

What is image copy in db2?

1019

what is the responsibility of the construction superintendent

2147

For More Un-Answered { DB2 } Questions Click Here