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 18605

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

3 8891

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

CTS, IBM, TCS,

9 15759

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 4932

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 23929

What is auditing?

2 5034

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

2 5117

When do you specify the isolation level? How?

1 5222

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

2 5455

What is the error code -803 ?

3 11802

What can the SET option of the Repair Utility accomplish?

1 5578

What are the levels of isolation available with DB2V4

IBM,

2 4609

Where are plans stored?

2 7139

What is a clustering index?

2 5558

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is innodb buffer pool?

1054

What is a db2 schema?

1233

Explain the benefits you can get from mainframe connect?

972

Why cursor is used in db2?

1036

What do you mean by cursor?

988

What is the use of predicate?

1043

What is a storage group (stogroup)?

1246

What is runstats db2?

1037

What is drop table?

1011

How do I delete a column in db2?

1109

Comment whether the cursor is closed during commit or not.

1106

Explain correlated sub-queries.

1033

what is utility for parm lib

2377

What is the maximum No of rows per page?

1069

Define buffer pool.

1056

For More Un-Answered { DB2 } Questions Click Here