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?

1027

What is meant by dclgen?

1061

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

1034

How is a typical db2 batch pgm executed?

1110

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

1025

Name the various locking levels available?

1036

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

1066

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

1056

How do you eliminate duplicate values in db2?

1110

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

1016

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

1101

When do you specify the isolation level?

974

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

962

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

1 1959

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

990

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is innodb buffer pool?

982

Define db2.

1067

List down the types of triggers in the db2 database?

965

What is consistency token in db2?

1067

Can you use max on a char column?

1031

What is temporal table in db2?

990

What is the use of with ur in db2?

1004

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

993

What is load utility in db2?

1132

Explain the function done by data manager?

1220

What is cursor with hold option in db2?

1013

Why do we bind in db2?

1143

What is the difference between dbm cfg and db cfg file in db2 ?

1481

What is the purpose of rollback and commit?

1089

What is an instance database?

1007

For More Un-Answered { DB2 } Questions Click Here