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?

1090

What is meant by dclgen?

1108

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

1090

How is a typical db2 batch pgm executed?

1174

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

1069

Name the various locking levels available?

1091

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

1124

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

1104

How do you eliminate duplicate values in db2?

1190

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

1075

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

1149

When do you specify the isolation level?

1030

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

1045

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

1 2062

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

1050

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is db2 instance?

1094

Define buffer pool.

1053

Name the various locking levels available?

1091

How to get the ddl of a table in db2?

1130

Explain packages.

1111

What is dbrm? What it contains?

1163

Why do we use cursor?

1099

How to create db2 table in mainframe?

1154

What is plan in cobol db2?

1137

Is db2 a programming language?

1048

Explain package in db2 and its advantages?

1215

What are types of indexes?

1071

How can you count the number of rows from a table tab?

1089

What is the picture clause of null indicator variable?

1138

How do I import data from excel to db2?

1071

For More Un-Answered { DB2 } Questions Click Here