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 17034

How to resolve -407 sql code in DB2?

Cap Gemini,

9 31588

How to resolve -504 sql code in DB2?

Cap Gemini,

2 18938

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

2 14373

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

4 7959

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 11932

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

1 7887

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 6238

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 8097

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 7235

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 7795

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 8930

how can we find nth max salary from A table

IBM,

5 26014

how to take the back up of the DB2 table.

7 21822

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

Syntel, UST,

4 7498

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is multi row fetch in db2?

1046

What is explain plan in db2?

989

How do we specify index to include or not during bind process.

2126

Which isolation level provides highest data integrity?

1114

How to execute stored procedures?

1130

What language is db2 written in?

1043

What is ibm db2 database?

998

What is the result of open cursor statement?

1081

What is the default page size of buffer pools?

1122

What is buffer pool and list some of them?

1027

What is host variable in db2 cobol?

1077

Is db2 relational database?

973

Explain the contents that are a part of dclgen.

1089

What is concurrency?

1229

what are bind concepts in db2 cobol?

1090

For More Un-Answered { DB2 } Questions Click Here