1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category
DB2 Interview Questions
Questions Answers Views Company eMail

What is a Resource Control Table(RCT)? Describe its characteristics.

 3 12301

How is the SUBSTR keyword used in sql?

 1 8702

What is an inner join, and an outer join ?

CTA,

1 12290

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

 1 7787

What is a root page?

 1 3809

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

 1 5133

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

 2 7479

Which catalog table stores referential constraints?

 1 5134

Give the COBOL definition of a VARCHAR field.

 2 16042

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

 2 10189

How to see the structure of db2 table??

IBM,

4 31782

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

IBM, TCS,

8 18327

What is normalization and what are the five normal forms?

 1 4350

What are simple, segmented and partitioned table spaces ?

TCS,

1 13003

What is dynamic SQL?

ADP,

1 5443

Post New DB2 Questions

Un-Answered Questions { DB2 }

Mention the definition of cobol in varchar field.

776

What is phantom read in db2?

720

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

1917

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

2381

How do I delete a table in db2?

730




What is the use of db2?

681

Why do we use cursor?

679

What are catalog tables in db2?

685

What is cascading rollback?

711

How is the value function used?

713

What is package in cobol db2?

773

How connect db2 database to datastage?

866

How to restart a DB2 program?

1453

What is node in db2?

690

How can you quickly find out the # of rows updated after an update statement?

704

For More Un-Answered { DB2 } Questions Click Here