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 6539

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 18330

What are the isolation levels possible ?

3 7039

What is meant by index cardinality?

2 6572

What does the RUNSTATS Utility do?

4 20654

What is the purpose of the QUIESE Utility?

1 5170

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

1 4364

What are column-name qualifiers used?

1 4302

Explain transactions, commits and rollbacks in DB2.

3 8189

How is a typical DB2 batch program executed ?

1 6633

What information is held in SYSIBM.SYSCOPY?

1 5858

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

1 4719

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

Mind Tree,

2 7523

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

IBM,

2 8979

what's the error code for Unique Index Violation?

2 8311

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is the usage of open cursor command?

1100

What does db2 stand for?

1023

What is null value in db2?

1019

Is the primary key a clustered index?

1141

What is db2 bind?

1078

What is the role of the data page in the db2 database?

1024

What do you mean by commit and rollback?

1035

What's The Error Code For Unique Index Voilation?

1233

What are the prerogatives?

1078

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3152

What is a system catalog table in db2?

1184

Explain in brief how does db2 determine what lock-size to use?

1038

What does runstats do in db2?

1110

Explain various types of locks in db2?

1140

How connect db2 database to datastage?

1234

For More Un-Answered { DB2 } Questions Click Here