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 5058

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

IBM,

1 5496

How does DB2 use multiple table indexes?

1 5891

What is meant by repeatable read?

4 10611

Compare a subselect to a join?

1 5079

Describe the elements of the SELECT query syntax?

3 6608

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

IBM,

2 9499

What is the FREE command?

1 5268

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

2906

What is DB2 (IBM Database 2)?

3 5776

What is QUIESCE?

2 13314

what is the name of the default db2 catalog database?

IBM,

3 8653

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

1 5478

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

1 5588

Explain the EXPLAIN statement?

1 5058

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is image copy in db2?

1069

What parameters are used to control the free space in DB2?

1094

Which components manage deadlocks in db2?

1119

What is commit in db2?

1104

What does reorg do in db2?

1074

How to compare data between two tables in db2?

1136

How to check last update on table in db2?

1097

What is null indicator in db2?

1162

How to get the ddl of a table in db2?

1168

What is the default page size of buffer pools?

1164

What is the maximum size of a char data type in db2?

1048

What is clone table?

1114

What are the prerogatives?

1127

What are the rules for db2 programming?

1153

What language is db2 written in?

1101

For More Un-Answered { DB2 } Questions Click Here