DB2 Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

DB2 Interview Questions

Questions Answers Views Company eMail

What is a DBRM, PLAN ?

3 18594

What's the maximum number of characters that a tablename can have?

3 8874

What technique is used to retrieve data from more than one table in a single SQL statement?

CTS, IBM, TCS,

9 15744

can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?

1 4929

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

2060

Why use RUNSTAT Utility?

Merrill Lynch,

3 23917

What is auditing?

2 5030

Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?

2 5112

When do you specify the isolation level? How?

1 5215

What do the initials DDL and DML stand for and what is their meaning?

2 5447

What is the error code -803 ?

3 11786

What can the SET option of the Repair Utility accomplish?

1 5571

What are the levels of isolation available with DB2V4

IBM,

2 4600

Where are plans stored?

2 7137

What is a clustering index?

2 5556

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is the difference between oracle and db2?

1100

What is database reorganization?

1125

How to run db2 command in windows?

1191

How do you simulate the explain of an embedded sql statement in spufi/qmf?

1084

What is a db2 collection?

1035

What does sqlcabc has?

1047

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1185

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

1073

Explain what are the various isolation levels possible?

1042

What is dbrm library?

1049

What is concurrency?

1229

What is runstats utility in db2?

1018

What is scrollable cursor in db2?

1055

What are db2 tables?

1123

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

1044

For More Un-Answered { DB2 } Questions Click Here