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

DB2 Interview Questions

Questions Answers Views Company eMail

What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?

4 22237

Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?

6 22421

Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?

3 7813

Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?

8 26823

Hi i need to write a query on the following requirement. SELECT COMM_TEXT INTO :WS_MIKM_COMM_TEXT FROM MPIPROD.MIKMV01 WHERE ACCOUNT_NO = :WFD_ACCOUNT_NO AND (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT AND SUBSTR(COMM_TEXT,47,14) = :WS_DENY_DESC) OR (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT) The above query is to be modified. The requirement is if both the fields are equal then that has to be given priority. In the above query if it satisfies any one it comes out without checking if both being equal is possible.

1 3659

Suppose if I need to update a column, how you do that using cursor?

Verizon,

2 8321

Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?

Verizon,

2 6430

For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?

3 6725

How to define the a field which accepts value till 99999.99 in db2

3 8731

i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?

4 7233

I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?

4 9479

How to resolve -805 error in DB2?

Cap Gemini,

1 36201

How to resolve -803 sql code in DB2?

Cap Gemini,

3 44382

How to resolve -818 sql code in DB2?

Cap Gemini,

2 24447

How to resolve -502 sql code in DB2?

Cap Gemini,

2 25339

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is explain plan in db2?

989

Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

2363

Is ibm db2 open source?

1072

What does db2 mean?

1013

What is commit in db2?

1053

List down the data types in the db2 database.

1117

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3152

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1270

Why do we need reorg in db2?

985

what is the sqlcode -501

13137

What is runstats db2?

1019

Explain about mirror activator disk mirroring?

1005

What is a system catalog table in db2?

1184

What is the difference between drop table and delete table?

1203

What is syscat in db2?

1001

For More Un-Answered { DB2 } Questions Click Here