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?

1083

What is meant by dclgen?

1103

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

1087

How is a typical db2 batch pgm executed?

1172

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

1066

Name the various locking levels available?

1089

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

1119

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

1101

How do you eliminate duplicate values in db2?

1172

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

1073

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

1148

When do you specify the isolation level?

1027

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

1037

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

1 2055

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

1049

Post New DB2 Questions

Un-Answered Questions { DB2 }

What os does db2 run on?

976

Which command is used to connect to a database in DB2 ? Give the Syntax.

1102

What is the information associated with sysibm.syslinks table?

1120

Define sqlca.

1104

How do I start db2 in windows?

1086

How many databases can be created inside an instance in db2 ?

1029

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1061

Is the primary key a clustered index?

1141

Which component is responsible for db2 startup and shutdown?

1033

What is cursor with hold option in db2?

1068

What is the advantage in De-normalizing tables in DB2?

1168

What language is db2 written in?

1042

Explain the contention situations caused by locks?

1069

What is rebind in db2?

1052

What are the bind parameters ibm db2?

1046

For More Un-Answered { DB2 } Questions Click Here