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 4963

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

IBM,

1 5424

How does DB2 use multiple table indexes?

1 5811

What is meant by repeatable read?

4 10460

Compare a subselect to a join?

1 4981

Describe the elements of the SELECT query syntax?

3 6505

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

IBM,

2 9412

What is the FREE command?

1 5179

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

2852

What is DB2 (IBM Database 2)?

3 5665

What is QUIESCE?

2 13199

what is the name of the default db2 catalog database?

IBM,

3 8543

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

1 5393

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

1 5473

Explain the EXPLAIN statement?

1 4980

Post New DB2 Questions

Un-Answered Questions { DB2 }

How do you concatenate the firstname and lastname from emp table to give a complete name?

1076

Which component is responsible for processing sql statements and selecting access paths?

1127

How do you eliminate duplicate values in db2?

1190

What is declare cursor?

1122

How do you find the maximum value in a column in db2?

1104

What is node in db2?

1044

What is with ur in db2?

1316

What is the maximum number of columns in a db2 table?

1283

What is plan in cobol db2?

1138

How do I optimize a query in db2?

1101

What are concurrency issues?

1097

What is the use of db2?

1055

What is cobol db2?

1000

What are iseries servers?

1075

How to retrieve rows from a db2 table in embedded sql?

1390

For More Un-Answered { DB2 } Questions Click Here