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 4966

What is isolation level?

4 7271

What is a predicate?

1 4772

What is ALTER ?

3 6876

What do you need to do before you do EXPLAIN?

1 5244

How do you insert a record with a nullable column?

2 6267

What is a result table?

1 5633

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

1 5018

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

1 4281

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

2 6437

The only place of VSAM KSDS in DB2 is?

IBM,

2 8004

What is DCLGEN?

2 15757

Where is the output of EXPLAIN stored?

2 6834

What is the function of buffer manager?

1 5754

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

2 6500

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is cloudant database?

1095

How to compare data between two tables in db2?

1084

Define sqlca.

1105

What do you mean by rollback?

989

What is the picture clause of null indicator variable?

1136

What is the role of the data page in the db2 database?

1024

What is a plan and package in db2?

1097

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 ?

2178

How do you eliminate duplicate values in db2?

1174

How does a cursor work?

983

Is db2 relational database?

973

Are views updateable?

1150

What does db2 stand for?

1023

What is ibm db2 database?

998

How many databases are there?

1052

For More Un-Answered { DB2 } Questions Click Here