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 5052

What is isolation level?

4 7426

What is a predicate?

1 4869

What is ALTER ?

3 6989

What do you need to do before you do EXPLAIN?

1 5323

How do you insert a record with a nullable column?

2 6352

What is a result table?

1 5715

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

1 5098

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

1 4349

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

2 6546

The only place of VSAM KSDS in DB2 is?

IBM,

2 8120

What is DCLGEN?

2 15860

Where is the output of EXPLAIN stored?

2 6940

What is the function of buffer manager?

1 5860

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

2 6589

Post New DB2 Questions

Un-Answered Questions { DB2 }

Is db2 a programming language?

1098

What is a bind in db2?

1100

What is meant by dclgen?

1170

What is db2 instance?

1165

what is the role of the cursor in db2?

1109

Which command is used to connect to a database in DB2 ? Give the Syntax.

1148

How can you do the explain of a dynamic sql statement?

1106

What is the use of db2?

1112

How to find the number of rows in a db2 table?

1154

List out the three types of page locks that can be held.

1192

Define db2.

1167

When do you specify the isolation level?

1070

How to check sequence on a table in db2?

1111

B37 abend during spufi?

1506

When the like statement is used?

1280

For More Un-Answered { DB2 } Questions Click Here