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

What is the maximum size of a char data type in db2?

456

What is cursor stability in db2?

642

What are the various data types available in db2?

508

Which component is used to execute the sql statements?

492

What are the rules for db2 programming?

520

Define db2 and its databases?

487

How can you quickly find out the # of rows updated after an update statement?

491

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

502

What are the 2 sqlcodes that are returned?

520

Where do you specify them?

549

When the like statement is used?

496

How to retrieve rows from a db2 table in embedded sql?

563

Are views updateable?

498

What is reorg?

481

How can you find out the # of rows updated after an update statement?

482


Post New DB2 Questions

Un-Answered Questions { DB2 }

Explain about rct in db2?

509


While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

1603


What is bind and rebind in db2?

491


Mention the downsides of page level lock.

585


What is the physical storage length of the data types date, time, and timestamp?

470






How do I delete a table in db2?

485


How does coalesce work?

458


When the like statement is used?

496


What is a buffer in memory?

463


List down the data types in the db2 database.

524


How can you classify the locks in db2?

509


What is the syntax for creating a table in the db2 database?

512


What is innodb buffer pool?

440


what are bind concepts in db2 cobol?

506


What is drop table?

445