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

DB2 Interview Questions

Questions Answers Views Company eMail

Where besides the DB2 catalog is database object information stored by DB2?

1 4883

What is isolation level?

4 7081

What is a predicate?

1 4685

What is ALTER ?

3 6746

What do you need to do before you do EXPLAIN?

1 5146

How do you insert a record with a nullable column?

2 6133

What is a result table?

1 5545

What is the SQL Communications Area and what are some of its key fields?

1 4924

Usually, which is more important for DB2 system performance - CPU processing or I/O access?

1 4202

How would one remove old reorg information from the DB2 catalog?

2 6333

The only place of VSAM KSDS in DB2 is?

IBM,

2 7868

What is DCLGEN?

2 15616

Where is the output of EXPLAIN stored?

2 6703

What is the function of buffer manager?

1 5650

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

2 6395

Post New DB2 Questions

Un-Answered Questions { DB2 }

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

2126

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1058

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3094

Define check constraint.

1029

Define db2.

1067

Can we insert update delete in view?

912

What is the result of open cursor statement?

1030

Is it possible using max on a char column?

1088

How to retrieve rows from a db2 table in embedded sql?

1330

What is reorg?

1077

What is commit in db2?

998

What is the information associated with sysibm.syslinks table?

1059

What do you mean by commit and rollback?

981

What is check constraint. Explain with example.

1047

Explain what are the various isolation levels possible?

991

For More Un-Answered { DB2 } Questions Click Here