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 13653

How is the SUBSTR keyword used in sql?

1 9435

What is an inner join, and an outer join ?

CTA,

1 13030

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

1 8442

What is a root page?

1 4419

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

1 5829

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

2 8345

Which catalog table stores referential constraints?

1 6022

Give the COBOL definition of a VARCHAR field.

2 16994

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

2 11306

How to see the structure of db2 table??

IBM,

4 33224

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

IBM, TCS,

8 20905

What is normalization and what are the five normal forms?

1 5247

What are simple, segmented and partitioned table spaces ?

TCS,

1 13803

What is dynamic SQL?

ADP,

1 6971

Post New DB2 Questions

Un-Answered Questions { DB2 }

How do I delete a table in db2?

1122

What is runstats db2?

1073

What do you mean by commit and rollback?

1087

How do I copy a table in db2?

1052

Explain packages.

1165

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

1106

What is collection in db2 bind?

1059

Can you tell me how can you find out the # of rows updated after an update statement?

1144

Explain dclgen.

1268

What is image copy in db2?

1069

Explain about rct in db2?

1160

What is iseries database?

1113

What is meant by explain?

1192

What are types of indexes?

1187

How connect db2 database to datastage?

1289

For More Un-Answered { DB2 } Questions Click Here