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 6641

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 18463

What are the isolation levels possible ?

3 7170

What is meant by index cardinality?

2 6673

What does the RUNSTATS Utility do?

4 20817

What is the purpose of the QUIESE Utility?

1 5232

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

1 4432

What are column-name qualifiers used?

1 4383

Explain transactions, commits and rollbacks in DB2.

3 8341

How is a typical DB2 batch program executed ?

1 6691

What information is held in SYSIBM.SYSCOPY?

1 5935

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

1 4792

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

Mind Tree,

2 7637

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

IBM,

2 9060

what's the error code for Unique Index Violation?

2 8422

Post New DB2 Questions

Un-Answered Questions { DB2 }

What parameters are used to control the free space in DB2?

1094

How can we read records for specific member in CL? AND rpg?

756

What is meant by dclgen?

1169

What is the use of db2?

1111

What is db2 and what is the use of db2 optimizer?

1108

Mention some fields that are a part of sqlca.

1090

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1148

How to restart a DB2 program?

1953

what is db2 restart?

2212

Give the name of some fields form sqlca.

1142

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

1223

What is the function of logging in the db2 database?

1172

What is image copy in db2?

1069

How do you pull up a query which was previously saved in qmf?

1202

How to find schema of a table in db2?

1063

For More Un-Answered { DB2 } Questions Click Here