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 13550

How is the SUBSTR keyword used in sql?

1 9342

What is an inner join, and an outer join ?

CTA,

1 12937

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 5964

Give the COBOL definition of a VARCHAR field.

2 16885

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

2 11160

How to see the structure of db2 table??

IBM,

4 33064

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

IBM, TCS,

8 20677

What is normalization and what are the five normal forms?

1 5142

What are simple, segmented and partitioned table spaces ?

TCS,

1 13737

What is dynamic SQL?

ADP,

1 6874

Post New DB2 Questions

Un-Answered Questions { DB2 }

Is ibm db2 open source?

1075

Explain the function done by data manager?

1280

What is database manager in db2?

1021

How can you do the explain of a dynamic sql statement?

1069

When do you specify the isolation level?

1030

Explain correlated sub-queries.

1032

What is a trigger in the db2 database?

1080

What are bind parameters in db2?

1046

What is the information associated with sysibm.syslinks table?

1123

How and when does the db2 enforces the unique key?

1083

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

1028

Differentiate between cs and rr isolation levels? Where do you specify them?

1069

Why db2 is called db2?

1039

What is a page in db2?

1027

Is it possible using max on a char column?

1139

For More Un-Answered { DB2 } Questions Click Here