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

DB2 Interview Questions

Questions Answers Views Company eMail

How to resolve -917 sql code in DB2?

Cap Gemini,

3 17192

How to resolve -407 sql code in DB2?

Cap Gemini,

9 31927

How to resolve -504 sql code in DB2?

Cap Gemini,

2 19045

What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?

2 14495

What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?

4 8111

if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.

Wipro,

8 12142

What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?

1 7965

5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?

2 6340

if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records

UST,

4 8226

i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error

UST,

3 7359

a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.

3 7944

in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.

iGate,

2 9060

how can we find nth max salary from A table

IBM,

5 26255

how to take the back up of the DB2 table.

7 22056

Can a array declared with an index be displayed(readable format) in spool?

Syntel, UST,

4 7645

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is concurrency?

1299

What is the physical storage length of date data type?

1304

What is a trigger in the db2 database?

1140

What is coalesce in db2?

1180

How to check sequence on a table in db2?

1111

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1147

What is the function of logging in the db2 database?

1172

What is copy pending status in db2?

1182

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

1173

What is the connection string to connect to the DB2 Database ?

1171

What does runstats do in db2?

1181

Give a brief description of db2 isolation levels?

1138

What is multi row fetch in db2?

1100

What are concurrency issues?

1170

What is db2 stogroup?

1220

For More Un-Answered { DB2 } Questions Click Here