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 13409

How is the SUBSTR keyword used in sql?

1 9243

What is an inner join, and an outer join ?

CTA,

1 12818

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

1 8289

What is a root page?

1 4246

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

1 5691

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

2 8139

Which catalog table stores referential constraints?

1 5878

Give the COBOL definition of a VARCHAR field.

2 16760

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

2 10974

How to see the structure of db2 table??

IBM,

4 32903

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

IBM, TCS,

8 20330

What is normalization and what are the five normal forms?

1 5024

What are simple, segmented and partitioned table spaces ?

TCS,

1 13630

What is dynamic SQL?

ADP,

1 6722

Post New DB2 Questions

Un-Answered Questions { DB2 }

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2172

How connect db2 database to datastage?

1192

What is dpf in db2?

1059

What is db2 instance?

1023

What is the maximum length of sqlca?

1441

What is performance tuning db2?

1010

What is the role of the data page in the db2 database?

978

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

966

Define db2.

1067

What is query_cache_limit?

930

What is release/acquire in bind?

1061

What is dbrm library?

1005

What is the syntax for FETCH in DB2 ?

1145

What is phantom read in db2?

1075

Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2674

For More Un-Answered { DB2 } Questions Click Here