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 13544

How is the SUBSTR keyword used in sql?

1 9340

What is an inner join, and an outer join ?

CTA,

1 12934

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

1 8366

What is a root page?

1 4348

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

1 5759

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

2 8233

Which catalog table stores referential constraints?

1 5957

Give the COBOL definition of a VARCHAR field.

2 16878

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

2 11154

How to see the structure of db2 table??

IBM,

4 33055

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

IBM, TCS,

8 20663

What is normalization and what are the five normal forms?

1 5139

What are simple, segmented and partitioned table spaces ?

TCS,

1 13729

What is dynamic SQL?

ADP,

1 6865

Post New DB2 Questions

Un-Answered Questions { DB2 }

How to execute stored procedure in db2 command editor?

1047

What is db2 instance?

1080

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2840

How is deadlock resolved?

1146

How to create db2 table in mainframe?

1154

How does db2 sample database connect?

1024

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

1038

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1101

What types of tables are there in the db2 database?

1055

What is cursor with hold option in db2?

1069

What is dbrm library?

1049

What does db2 blu stand for?

1165

What do you mean by storage group (stogroup)?

1039

What is check constraint. Explain with example.

1101

What parameters are used to control the free space in DB2?

1056

For More Un-Answered { DB2 } Questions Click Here