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 6563

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 18365

What are the isolation levels possible ?

3 7060

What is meant by index cardinality?

2 6582

What does the RUNSTATS Utility do?

4 20677

What is the purpose of the QUIESE Utility?

1 5171

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

1 4372

What are column-name qualifiers used?

1 4314

Explain transactions, commits and rollbacks in DB2.

3 8212

How is a typical DB2 batch program executed ?

1 6643

What information is held in SYSIBM.SYSCOPY?

1 5878

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

1 4731

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

Mind Tree,

2 7542

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

IBM,

2 8987

what's the error code for Unique Index Violation?

2 8329

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is bind plan?

1056

Define sqlca.

1119

What is the use of runstats in db2?

1115

What is the purpose of rollback and commit?

1199

What kind of database is db2?

1038

Can there be more than one cursor open for any program?

1173

How many databases are there?

1061

How to retrieve rows from a db2 table in embedded sql?

1397

Mention the various locks that are available in db2.

1045

What is a bind in db2?

1049

What is the difference between cursor and select statement?

1114

What is db2 stogroup?

1167

What is the syntax for seeing the columns and data types of a table in the db2 database?

1172

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

1116

What do you mean by cursor?

994

For More Un-Answered { DB2 } Questions Click Here