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

DB2 Interview Questions

Questions Answers Views Company eMail

What is a lock?

1 4252

What should be specified along with a cursor in order to continue updating process after commit?

IBM,

1 4344

How does DB2 use multiple table indexes?

1 5010

What is meant by repeatable read?

4 8848

Compare a subselect to a join?

1 4138

Describe the elements of the SELECT query syntax?

3 5219

What is the command used by TSO users to invoke DB2?

IBM,

2 8432

What is the FREE command?

1 4360

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2288

What is DB2 (IBM Database 2)?

3 4377

What is QUIESCE?

2 12192

what is the name of the default db2 catalog database?

IBM,

3 7288

What are the three DB2 date and time data types and their associated functions?

1 4652

What is the significance of DB2 free space and what parameters control it?

1 4702

Explain the EXPLAIN statement?

1 4255

Post New DB2 Questions

Un-Answered Questions { DB2 }

Mention data types used in db2 ?

685

How connect db2 database to datastage?

769

what is the sqlcode -501

11316

What does db2 stand for?

604

What is reorg?

622

What is the clustering index in the db2 database?

588

Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2327

Mention the location where the output received from explain statement is stored.

635

What is the purpose of using commit?

622

What is an instance in db2?

567

List out the buffer pools in db2

637

How is the value function used?

606

What is db2?

747

What is buffer pool?

619

What is dclgen (declaration generator)?

605

For More Un-Answered { DB2 } Questions Click Here