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?

1024

What is meant by dclgen?

1060

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

1032

How is a typical db2 batch pgm executed?

1108

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

1022

Name the various locking levels available?

1035

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

1063

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

1052

How do you eliminate duplicate values in db2?

1107

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

1011

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

1099

When do you specify the isolation level?

972

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

959

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

1 1956

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

988

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is sqlca?

999

What is reorg and runstats in db2?

1143

what is diffrence b/w file-aid tool and file-aid utility???

4809

What is package in db2 mainframe?

917

How to find primary key of a table in db2?

1001

What is the use of db2?

1005

What is the maximum No of rows per page?

1011

What is a db2 table?

954

What is the clustering index in the db2 database?

955

What is the purpose of rollback and commit?

1086

What is commit in db2?

996

What is cloudant database?

1032

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

1052

What do you mean by between and in? Is between inclusive of specified range values?

1038

What is query_cache_limit?

928

For More Un-Answered { DB2 } Questions Click Here