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 6553

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 18346

What are the isolation levels possible ?

3 7053

What is meant by index cardinality?

2 6576

What does the RUNSTATS Utility do?

4 20666

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 4370

What are column-name qualifiers used?

1 4308

Explain transactions, commits and rollbacks in DB2.

3 8203

How is a typical DB2 batch program executed ?

1 6636

What information is held in SYSIBM.SYSCOPY?

1 5869

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

1 4727

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

Mind Tree,

2 7532

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

IBM,

2 8982

what's the error code for Unique Index Violation?

2 8317

Post New DB2 Questions

Un-Answered Questions { DB2 }

How to test SQL -911 error while developing COB-DB2 program

7567

What is dpf in db2?

1109

What is the result of open cursor statement?

1083

What is bind in db2?

1044

What is the difference between dbm cfg and db cfg file in db2 ?

1536

What is bind and rebind in db2?

1139

My sql statement select avg(salary) from emp yields inaccurate results. Why?

1095

What is cursor with hold option in db2?

1073

How to create db2 table in mainframe?

1154

Explain correlated sub-queries.

1033

What is clone table?

1042

Which command is used to connect to a database in DB2 ? Give the Syntax.

1104

Is db2 relational database?

979

Why do chiropractors use drop table?

1109

What are bind parameters in db2?

1047

For More Un-Answered { DB2 } Questions Click Here