DB2 Interview Questions
Questions Answers Views Company eMail

What is dbrm? When it will be created?

591

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

620

What is dbrm? What it contains?

671

What does sqlcabc has?

625

What is the difference between cursor stability and repeatable read isolation levels?

668

How to execute stored procedures?

615

What is sqlca?

608

Are view updateable?

624

How and when does the db2 enforces the unique key?

609

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

693

What is dbrm? What it contains? When it will be created?

589

What is the difference between spufi and qmf?

633

What is the max length of sqlca?

756

What are the bind parameters ibm db2?

618

what are bind concepts in db2 cobol?

643


Post New DB2 Questions

Un-Answered Questions { DB2 }

What is reorg and runstats in db2?

683


Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

598


When reorg is used?

666


What is the result of open cursor statement?

630


What is the difference between plan and package in db2?

565






How can you do the explain of a dynamic sql statement?

628


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

652


What is the purpose of using commit?

611


What is the use of predicate?

578


What is universal database?

608


Where do you specify them?

672


How to find schema of a table in db2?

564


What is plan in cobol db2?

581


Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

620


Can we insert update delete in view?

568