Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

DB2 Interview Questions
Questions Answers Views Company eMail

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

3 10614

How is the SUBSTR keyword used in sql?

1 7780

What is an inner join, and an outer join ?

CTA,

1 11333

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

1 6726

What is a root page?

1 3013

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

1 4177

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

2 6270

Which catalog table stores referential constraints?

1 4211

Give the COBOL definition of a VARCHAR field.

2 14749

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

2 8515

How to see the structure of db2 table??

IBM,

4 29941

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

IBM, TCS,

8 14645

What is normalization and what are the five normal forms?

1 3517

What are simple, segmented and partitioned table spaces ?

TCS,

1 10917

What is dynamic SQL?

ADP,

1 3957


Post New DB2 Questions






Un-Answered Questions { DB2 }

What is a db2 tablespace?

185


Which command is used to connect to a database in DB2 ? Give the Syntax.

214


What is a db2 collection?

176


How is the value function used?

173


What is host variable?

173






Comment whether the cursor is closed during commit or not.

213


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

221


What is a system catalog table in db2?

217


What is sqlca?

216


What is runstats utility in db2?

170


What is the role of union all and union

230


What is the result of open cursor statement?

225


What is the function of logging in the db2 database?

205


How would the varchar column remarks defined?

222


B37 abend during spufi?

299