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 6549

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 18342

What are the isolation levels possible ?

3 7047

What is meant by index cardinality?

2 6575

What does the RUNSTATS Utility do?

4 20660

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 4368

What are column-name qualifiers used?

1 4306

Explain transactions, commits and rollbacks in DB2.

3 8199

How is a typical DB2 batch program executed ?

1 6634

What information is held in SYSIBM.SYSCOPY?

1 5868

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

1 4726

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

Mind Tree,

2 7529

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

IBM,

2 8981

what's the error code for Unique Index Violation?

2 8316

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is the use of dclgen in db2?

1085

What is db2 command?

1036

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2852

What are the bind parameters ibm db2?

1053

What is reorg and runstats in db2?

1218

Why select is not preferred in embedded sql programs?

1299

What is bind and rebind in db2?

1138

What is a Foreign Key?

1095

What is catalog database in db2?

1163

Explain how can you do the explain of a dynamic sql statement?

1125

i want to maintain uniqueness on pdf without make lf??????????

2156

Explain the benefits you can get from mainframe connect?

971

What is the use of value function?

1150

How and when does the db2 enforces the unique key?

1083

What is plan in cobol db2?

1138

For More Un-Answered { DB2 } Questions Click Here