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 12000

How is the SUBSTR keyword used in sql?

1 8506

What is an inner join, and an outer join ?

CTA,

1 12089

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

1 7577

What is a root page?

1 3648

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

1 4936

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

2 7212

Which catalog table stores referential constraints?

1 4908

Give the COBOL definition of a VARCHAR field.

2 15775

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

2 9841

How to see the structure of db2 table??

IBM,

4 31357

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

IBM, TCS,

8 17696

What is normalization and what are the five normal forms?

1 4171

What are simple, segmented and partitioned table spaces ?

TCS,

1 12697

What is dynamic SQL?

ADP,

1 5067

Post New DB2 Questions

Un-Answered Questions { DB2 }

How to compare data between two tables in db2?

648

What is the difference between drop table and delete table?

537

B37 abend during spufi?

969

What is cobol db2?

554

How to take backup of table in db2?

587

How do you simulate the explain of an embedded sql statement in spufi/qmf?

625

Which isolation level provides maximum concurrency?

649

What is the difference between cursor and select statement?

605

What do you mean by cursor?

573

What is db2 plan table?

606

Define buffer pool.

614

Explain packages.

651

How is deadlock resolved?

638

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

3778

What is db2? Explain.

593

For More Un-Answered { DB2 } Questions Click Here