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 17044

How to resolve -407 sql code in DB2?

Cap Gemini,

9 31614

How to resolve -504 sql code in DB2?

Cap Gemini,

2 18946

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 7973

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 11951

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

1 7896

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 6245

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 8112

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 7247

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 7803

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 8943

how can we find nth max salary from A table

IBM,

5 26026

how to take the back up of the DB2 table.

7 21843

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

Syntel, UST,

4 7507

Post New DB2 Questions

Un-Answered Questions { DB2 }

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

1272

What is declare cursor?

1123

What is reorg and runstats in db2?

1219

What is the use of reorg in db2?

1086

What is db2 plan table?

1050

What are types of indexes?

1074

What is the use of predicate?

1043

Explain the benefits you can get from mainframe connect?

972

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1102

What is the role of data manager in the db2 database?

1109

What is the physical storage length of date data type?

1254

What is role in db2?

1109

Can we delete records from view?

967

How do you stop a db2 database in linux?

1014

How do I import a csv file into db2?

991

For More Un-Answered { DB2 } Questions Click Here