DB2 Interview Questions
Questions Answers Views Company eMail

Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?

1 5182

What is the database descriptor?

2 12986

What is the syntax required for the creation of a cursor?

1 8532

What is meant by AUTO COMMIT?

3 8831

What information is contained in a SYSCOPY entry?

2 8891

What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?

Emsang,

5 18699

What is lock contention?

1 4743

Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?

1 3757

What is COPY PENDING status?

6 34685

What is IMAGECOPY ?

6 37017

What are the functions of Bind?

Amdocs, IBM,

2 7153

What is a cursor?

2 5547

When is the authorization check on DB2 objects done - at BIND time or run time?

1 12467

What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?

2 4245

What can the Locate option of the Repair Utility accomplish?

2 4648


Post New DB2 Questions

Un-Answered Questions { DB2 }

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.

2739


What is the difference between db2 and oracle?

659


What is a db2 cursor?

607


What is explain plan in db2?

575


What is the difference between cursor and select statement?

603






What is null value in db2?

548


Is db2 a database?

564


File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2365


Explain about rct.

633


What is copy pending and check pending in db2?

565


what is diffrence b/w file-aid tool and file-aid utility???

4152


What are the contents of a dclmgen?

619


What is ibm db2 database?

524


How to find the number of rows in a db2 table?

638


List down the types of triggers in the db2 database?

576