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 12014

How is the SUBSTR keyword used in sql?

 1 8518

What is an inner join, and an outer join ?

CTA,

1 12105

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

 1 7591

What is a root page?

 1 3662

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

 1 4952

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

 2 7225

Which catalog table stores referential constraints?

 1 4918

Give the COBOL definition of a VARCHAR field.

 2 15792

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

 2 9868

How to see the structure of db2 table??

IBM,

4 31377

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

IBM, TCS,

8 17727

What is normalization and what are the five normal forms?

 1 4183

What are simple, segmented and partitioned table spaces ?

TCS,

1 12712

What is dynamic SQL?

ADP,

1 5086

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is drop table?

576

What is db2 stogroup?

668

Define buffer pool.

616

Can we insert update delete in view?

567

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

1567




Comment whether the cursor is closed during commit or not.

660

What are packages in db2?

590

What is db2?

735

What is bind and rebind in db2?

640

What are the full forms of spufi and dclgen and why are they used?

646

What are the two types of logging in the db2 database? Explain them.

568

Explain the contents that are a part of dclgen.

650

What is host variable?

585

What is the clustering index in the db2 database?

575

What is an instance database?

589

For More Un-Answered { DB2 } Questions Click Here