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?

1051

What is meant by dclgen?

1071

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

1051

How is a typical db2 batch pgm executed?

1124

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

1035

Name the various locking levels available?

1053

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

1080

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

1075

How do you eliminate duplicate values in db2?

1122

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

1035

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

1114

When do you specify the isolation level?

986

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

984

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

1 1982

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

1005

Post New DB2 Questions

Un-Answered Questions { DB2 }

Explain the contents that are a part of dclgen.

1048

What is a db2 schema?

1191

Explain about mirror activator disk mirroring?

968

What is host variable in db2 cobol?

1043

Which is faster delete or truncate?

1081

What is the connection string to connect to the DB2 Database ?

1076

Is db2 relational database?

935

What is innodb buffer pool?

998

Which are the db2 tools to protect integrity of the database?

1084

What is the maximum No of rows per page?

1028

What are db2 objects?

1010

If I have a view which is a join of two or more tables, can this view be updateable?

1096

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

1051

Explain the contention situations caused by locks?

1026

What is db2 bind?

1025

For More Un-Answered { DB2 } Questions Click Here