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 4978

What is isolation level?

4 7282

What is a predicate?

1 4778

What is ALTER ?

3 6879

What do you need to do before you do EXPLAIN?

1 5248

How do you insert a record with a nullable column?

2 6280

What is a result table?

1 5642

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

1 5028

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 6453

The only place of VSAM KSDS in DB2 is?

IBM,

2 8013

What is DCLGEN?

2 15764

Where is the output of EXPLAIN stored?

2 6846

What is the function of buffer manager?

1 5762

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

2 6509

Post New DB2 Questions

Un-Answered Questions { DB2 }

How can you count the number of rows from a table tab?

1091

What is nvl in db2?

1093

What is the use of db2?

1057

What is plan in cobol db2?

1139

What is the difference between db2 and oracle?

1133

What are the contents of a dclmgen?

1128

Mention the downsides of page level lock.

1161

What is the purpose of using commit?

1098

What is meant by dclgen?

1109

What is the use of value function?

1151

What is the clustering index in the db2 database?

1001

Name the lockable units in DB2?

1128

What is ibm db2 client?

939

What is a page in db2?

1027

Is the primary key a clustered index?

1149

For More Un-Answered { DB2 } Questions Click Here