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 13560

How is the SUBSTR keyword used in sql?

1 9350

What is an inner join, and an outer join ?

CTA,

1 12944

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

1 8373

What is a root page?

1 4356

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

1 5772

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

2 8251

Which catalog table stores referential constraints?

1 5979

Give the COBOL definition of a VARCHAR field.

2 16897

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

2 11172

How to see the structure of db2 table??

IBM,

4 33076

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

IBM, TCS,

8 20705

What is normalization and what are the five normal forms?

1 5154

What are simple, segmented and partitioned table spaces ?

TCS,

1 13746

What is dynamic SQL?

ADP,

1 6886

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is the meaning concurrency in the db2 database?

1112

Which isolation level provides highest data integrity?

1128

What's The Percentage Free Space ?

1228

How do you stop a db2 database in linux?

1020

How to get the ddl of a table in db2?

1134

How do I change the column size in db2?

1161

What do you mean by storage group (stogroup)?

1044

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

1074

What is db2? Explain.

1052

How will you return the number of records in table?

944

What is the physical storage length of the data types date, time, and timestamp?

1094

How do you select a row using indexes in db2?

1141

What is explain in db2?

1036

How to find the number of rows in a db2 table?

1121

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1278

For More Un-Answered { DB2 } Questions Click Here