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 18725

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

3 8998

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

CTS, IBM, TCS,

9 16020

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 4999

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?

2106

Why use RUNSTAT Utility?

Merrill Lynch,

3 24056

What is auditing?

2 5134

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

2 5221

When do you specify the isolation level? How?

1 5319

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

2 5568

What is the error code -803 ?

3 11937

What can the SET option of the Repair Utility accomplish?

1 5644

What are the levels of isolation available with DB2V4

IBM,

2 4726

Where are plans stored?

2 7235

What is a clustering index?

2 5648

Post New DB2 Questions

Un-Answered Questions { DB2 }

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1241

What happens in bind step in a db2 program?

1009

What is phantom read in db2?

1222

What do you mean by rollback?

1028

How do I connect my db2 database to ibm?

1084

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1109

What is clone table?

1114

How many types of page locks can be held in db2?

1087

What is cursor in dbms?

1112

What is cloudant database?

1153

What is iseries database?

1113

What are the various data types available in db2?

1143

How will you return the number of records in table?

986

How do I add a column to an existing table in db2?

1080

What are host variables in db2?

1120

For More Un-Answered { DB2 } Questions Click Here