DB2 Interview Questions
Questions Answers Views Company eMail

Explain the contents that are a part of dclgen.

649

Comment whether the cursor is closed during commit or not.

660

Define predicate?

632

Explain about cursor stability?

610

List out the buffer pools in db2

615

What is a storage group (stogroup)?

766

Explain dclgen.

712

What is sqlca’s maximum length?

662

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

629

Define declaration generator (dclgen).

657

Define data page.

622

Mention the different locking levels that are available in db2.

631

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

649

Discuss about db2 bind?

658

List out the data types available.

692


Post New DB2 Questions

Un-Answered Questions { DB2 }

What is db2 purescale?

537


I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

2744


What is precompiler in db2?

579


What are db2 objects?

630


Explain the benefits you can get from mainframe connect?

514






What is a page in db2?

600


What is db2 catalog database?

572


On which levels locks can be applied?

649


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

634


How to connect to db2 database from windows command line?

553


Explain db2.

605


What is the maximum size of varchar data type in db2?

636


If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

1567


What is the physical storage length of timestamp data type?

638


How to find schema of a table in db2?

562