Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

DB2 Interview Questions
Questions Answers Views Company eMail

Name some fields from SQLCA.

2 4614

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 14336

What are the isolation levels possible ?

3 4397

What is meant by index cardinality?

2 4710

What does the RUNSTATS Utility do?

4 17193

What is the purpose of the QUIESE Utility?

1 3684

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

1 2932

What are column-name qualifiers used?

1 2885

Explain transactions, commits and rollbacks in DB2.

3 5911

How is a typical DB2 batch program executed ?

1 5138

What information is held in SYSIBM.SYSCOPY?

1 4306

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

1 3380

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

Mind Tree,

2 5244

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

IBM,

1 5525

what's the error code for Unique Index Violation?

2 6265


Post New DB2 Questions






Un-Answered Questions { DB2 }

Can we insert update delete in view?

188


What are the rules for db2 programming?

261


B37 abend during spufi?

323


What is the maximum number of columns in a db2 table?

267


What is temporal table in db2?

183






What is runstats db2?

208


Why do chiropractors use drop table?

199


What is a system catalog table in db2?

241


What are the uses of db2 optimizer?

380


What is the maximum No of rows per page?

269


How do I delete a table in db2?

208


What is buffer pool in the db2 database?

225


what is utility for parm lib

1321


How to find the maximum value in a column in the db2 database?

227


What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

220