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 17040

How to resolve -407 sql code in DB2?

Cap Gemini,

9 31606

How to resolve -504 sql code in DB2?

Cap Gemini,

2 18944

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

2 14380

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

4 7972

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 11948

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

1 7893

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 6244

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 8103

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 7245

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 7797

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 8941

how can we find nth max salary from A table

IBM,

5 26018

how to take the back up of the DB2 table.

7 21831

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

Syntel, UST,

4 7504

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is the physical storage length of the data types date, time, and timestamp?

1087

What's The Percentage Free Space ?

1224

What is meant by dclgen?

1109

Explain about mirror activator disk mirroring?

1009

Where can you declare a cursor in a cobol-db2 program?

1077

What is db2 bind process?

1237

What is the use of value function?

1150

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

2097

can all users have the privilage to use the sql statement select * (dml)?

1168

What is difference between rollback and commit?

1157

What is the usage of open cursor command?

1100

What types of tables are there in the db2 database?

1056

What is the latest version of ibm db2?

1269

How to create backup table in db2?

1090

What are the different types of base tables?

1092

For More Un-Answered { DB2 } Questions Click Here