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 18625

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

3 8897

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

CTS, IBM, TCS,

9 15787

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 4935

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?

2064

Why use RUNSTAT Utility?

Merrill Lynch,

3 23953

What is auditing?

2 5047

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

2 5123

When do you specify the isolation level? How?

1 5230

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

2 5468

What is the error code -803 ?

3 11821

What can the SET option of the Repair Utility accomplish?

1 5583

What are the levels of isolation available with DB2V4

IBM,

2 4621

Where are plans stored?

2 7145

What is a clustering index?

2 5565

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is table space in db2?

1025

What is explain in db2?

1036

Why db2 is called db2?

1051

Name the various locking levels available?

1101

How do I optimize a query in db2?

1105

What is db2 and what is the use of db2 optimizer?

1071

What is package in cobol db2?

1121

what are bind concepts in db2 cobol?

1099

How to run db2 command in windows?

1200

What is data manager?

1056

What is ibm db2 used for?

1087

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

2249

What is query_cache_limit?

977

Define data page.

1075

ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

2073

For More Un-Answered { DB2 } Questions Click Here