DB2 Interview Questions
Questions Answers Views Company eMail

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

1551

Hi this is sures. i need to practice the ibm mainframes.could u telme how can i get userid from IBM.how much cost they will collect for one user id.can send me the details please.thanq

2 4611

i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?

Cap Gemini, CGI, EDS, IBM, Satyam, Wipro,

8 11660

wht happens if we close cursor with cursor with hold option?

Valtech,

3 11016

what is main use of table space and index object? please its urgent

CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,

5 13889

What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.

IBM,

3 16631

How can i install db2 9.x on AIX based system..? plz reply the detailed steps involved....?

IBM, TCS,

1648

How can we define a table? How can we apply SEARCH ALL on it ?

1 3694

Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?

Deloitte,

2 5543

what is the use of commit ? and what is the syntax?

Deloitte,

2 9150

what is the difference between declaring the cursor in WS section and Procedure division?

HCL,

1 7392

Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.

Cap Gemini,

9 11224

COBOL PRECOMPILER ERROR: "XXXXXX" (TABLE) PREVIOUSLY DECLARED OR REFERENCED DCLGEN VARIABLES GETS IMPORTED TWICE FOR ONLY ONE EXEC SQL STATEMENT. WHAT COULD BE THE PROBLEM?

1 9082

Can any one tell me about Restart logic in DB2.

2 6297

Do we need cursor for Count(*)?

iGate,

4 7483


Post New DB2 Questions

Un-Answered Questions { DB2 }

How do I connect my db2 database to ibm?

579


Can you use max on a char column?

618


What is a storage group (stogroup)?

751


What is a dbrm in db2?

556


Which isolation level provides maximum concurrency?

641






How does db2 sample database connect?

553


What is bind package and plan in db2?

568


What is phantom read in db2?

615


What is cursor stability in db2?

786


What are db2 objects?

619


How do I add a column to a table in db2?

593


SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

10633


Why db2 is called db2?

577


How to restart a DB2 program?

1334


What are concurrency issues?

601