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

DB2 Interview Questions

Questions Answers Views Company eMail

how can u retrieve the data from null values using applicaion program.

TCS,

3 8791

What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)

2 11333

Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?

IBM,

1 6242

what is the differences between spufi and qmf and which is better?

Accenture, Cap Gemini,

4 11946

i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process

2 6609

Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?

L&T, UST,

2 4679

Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?

UST,

1 6071

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

IBM,

2211

is it possible to get -811 error when you use cursors. why?

IBM,

2 7104

DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?

IBM,

1 6098

can you use symbolic parameters in JOB?

IBM,

5 8011

in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?

IBM,

1 4815

How to solve S0C7 abend with out using DISPlay in 10 mins?

IBM,

1 7104

What is usage pointer in cobol?

IBM,

3 16372

Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.

IBM,

3 8163

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is the difference between spufi and qmf?

1130

What is db2 and what is the use of db2 optimizer?

1065

How do I delete a table in database?

1020

What is cursor with hold option in db2?

1072

What is a db2 schema?

1229

Can you use max on a char column?

1097

What are the two types of logging in the db2 database? Explain them.

1073

What is a trigger in the db2 database?

1080

What is the picture clause of null indicator variable?

1138

What is lock escalation in db2?

1031

Explain correlated sub-queries.

1032

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2852

What is db2 bind process?

1237

What is role in db2?

1107

What is the cobol picture clause of the db2 data types date, time, timestamp?

1066

For More Un-Answered { DB2 } Questions Click Here