DB2 Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

DB2 Interview Questions

Questions Answers Views Company eMail

Name some fields from SQLCA.

2 6428

what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID register contain?

Cap Gemini, Tech Mahindra,

3 18119

What are the isolation levels possible ?

3 6894

What is meant by index cardinality?

2 6445

What does the RUNSTATS Utility do?

4 20470

What is the purpose of the QUIESE Utility?

1 5087

What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?

1 4269

What are column-name qualifiers used?

1 4216

Explain transactions, commits and rollbacks in DB2.

3 8021

How is a typical DB2 batch program executed ?

1 6534

What information is held in SYSIBM.SYSCOPY?

1 5777

What DB2 Catalog column tell you when an index needs table reorganized ?

1 4625

When can an insert of a new primary key value threaten referential integrity?

Mind Tree,

2 7401

what are the max. & min. no. of partitions allowed in a partition tablespace?

IBM,

2 8862

what's the error code for Unique Index Violation?

2 8151

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is a db2 table?

959

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

3147

Mention some fields that are a part of sqlca.

972

How do I import data from excel to db2?

1015

Is db2 a mainframe database?

946

What does db2 mean?

957

What are the different types of base tables?

1029

What is lock escalation in db2?

969

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

2181

What is copy pending status in db2?

1071

What are db2 tables?

1053

Explain about open switch business continuity software?

1074

What is a collection in db2?

986

What is ibm db2 connect?

932

How can you do the explain of a dynamic sql statement?

1018

For More Un-Answered { DB2 } Questions Click Here