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

DB2 Interview Questions

Questions Answers Views Company eMail

How do you simulate the explain of an embedded sql statement in spufi/qmf?

1138

What is meant by dclgen?

1169

My sql statement select avg(salary) from emp yields inaccurate results. Why?

1129

How is a typical db2 batch pgm executed?

1221

Differentiate between cs and rr isolation levels? Where do you specify them?

1115

Name the various locking levels available?

1129

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

1173

How do you find the maximum value in a column in db2?

1151

How do you eliminate duplicate values in db2?

1260

How do you concatenate the firstname and lastname from emp table to give a complete name?

1114

How do you pull up a query which was previously saved in qmf?

1202

When do you specify the isolation level?

1069

Explain in brief how does db2 determine what lock-size to use?

1085

How do you retrieve the first 5 characters of firstname column of db2 table emp?

1 2127

How would you find out the total number of rows in a db2 table?

1094

Post New DB2 Questions

Un-Answered Questions { DB2 }

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

1137

Who uses db2?

1110

What is a bind in db2?

1100

What is rct?

1285

Comment whether the cursor is closed during commit or not.

1167

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

2088

What kind of database is db2?

1080

What is the difference between spufi and qmf?

1200

what are bind concepts in db2 cobol?

1137

What are db2 objects?

1085

How do you concatenate the firstname and lastname from emp table to give a complete name?

1114

Which command is used to connect to a database in DB2 ? Give the Syntax.

1146

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

2434

Why cursor is used in db2?

1085

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

1082

For More Un-Answered { DB2 } Questions Click Here