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?

1092

What is meant by dclgen?

1109

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

1095

How is a typical db2 batch pgm executed?

1176

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

1071

Name the various locking levels available?

1093

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

1125

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

1106

How do you eliminate duplicate values in db2?

1192

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

1077

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

1149

When do you specify the isolation level?

1032

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 2065

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

1052

Post New DB2 Questions

Un-Answered Questions { DB2 }

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1240

What is the use of commit in db2?

1083

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

3210

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

2126

What is check constraint in db2?

1089

How to retrieve rows from a db2 table in embedded sql?

1390

How do I change the column size in db2?

1157

What is the syntax for creating a table in the db2 database?

1107

What is the purpose of using commit?

1098

How do I add a column to an existing table in db2?

1032

What is the picture clause of null indicator variable?

1138

Can we update view in db2?

1003

can all users have the privilage to use the sql statement select * (dml)?

1170

How to find the maximum value in a column in the db2 database?

1084

What is catalog database in db2?

1165

For More Un-Answered { DB2 } Questions Click Here