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 18410

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

3 8731

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

CTS, IBM, TCS,

9 15408

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 4848

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?

2016

Why use RUNSTAT Utility?

Merrill Lynch,

3 23752

What is auditing?

2 4912

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

2 5004

When do you specify the isolation level? How?

1 5074

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

2 5340

What is the error code -803 ?

3 11625

What can the SET option of the Repair Utility accomplish?

1 5476

What are the levels of isolation available with DB2V4

IBM,

2 4501

Where are plans stored?

2 7024

What is a clustering index?

2 5436

Post New DB2 Questions

Un-Answered Questions { DB2 }

what is the role of the cursor in db2?

1003

What is the picture clause of null indicator variable?

1087

What is null in db2?

950

What is db2 instance?

1023

can all users have the privilage to use the sql statement select * (dml)?

1108

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11618

What is db2 look?

978

What r the comman abends in db2, jcl and cobol???????

2202

How does coalesce work?

964

What is a bind in db2?

989

What is the max length of sqlca?

1162

What is dbrm? When it will be created?

964

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

1017

What os does db2 run on?

929

What is ibm db2 client?

886

For More Un-Answered { DB2 } Questions Click Here