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 4979

What is isolation level?

4 7285

What is a predicate?

1 4783

What is ALTER ?

3 6882

What do you need to do before you do EXPLAIN?

1 5252

How do you insert a record with a nullable column?

2 6282

What is a result table?

1 5642

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

1 5029

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

1 4284

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

2 6459

The only place of VSAM KSDS in DB2 is?

IBM,

2 8016

What is DCLGEN?

2 15765

Where is the output of EXPLAIN stored?

2 6847

What is the function of buffer manager?

1 5764

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

2 6514

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is image copy in db2?

1021

How connect db2 database to datastage?

1244

What is the result of open cursor statement?

1083

Explain how can you do the explain of a dynamic sql statement?

1125

What is the information associated with sysibm.syslinks table?

1125

What is the function of logging in the db2 database?

1123

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

2254

What is collection in db2 bind?

1017

What is reorg?

1162

Define predicate?

1139

How to create db2 table in mainframe?

1154

What are union and union all?

983

What db2 400?

1194

Is db2 a database?

979

Is db2 a programming language?

1051

For More Un-Answered { DB2 } Questions Click Here