DB2 Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

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

2045

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 5573

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 14152

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

Valtech,

3 12400

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 16163

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 18585

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

IBM, TCS,

2149

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

1 4654

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 7341

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

Deloitte,

2 10317

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

HCL,

1 8441

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 14602

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 10185

Can any one tell me about Restart logic in DB2.

2 7305

Do we need cursor for Count(*)?

iGate,

4 9028

Post New DB2 Questions

Un-Answered Questions { DB2 }

Which component is used to execute the sql statements?

1096

Explain the contention situations caused by locks?

1070

How to connect to db2 database from windows command line?

1066

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

1104

What do you mean by storage group (stogroup)?

1041

Mention the different locking levels that are available in db2.

1136

Can we update view in db2?

1003

Differentiate between cs and rr isolation levels? Where do you specify them?

1071

Name the various locking levels available?

1093

What are the different types of base tables?

1094

What is db2 purescale?

1004

What is dbrm? When it will be created?

1029

Explain how can you do the explain of a dynamic sql statement?

1125

Is db2 a programming language?

1049

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

1135

For More Un-Answered { DB2 } Questions Click Here