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 4976

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

IBM,

1 5437

How does DB2 use multiple table indexes?

1 5824

What is meant by repeatable read?

4 10473

Compare a subselect to a join?

1 4994

Describe the elements of the SELECT query syntax?

3 6515

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

IBM,

2 9423

What is the FREE command?

1 5190

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

2860

What is DB2 (IBM Database 2)?

3 5678

What is QUIESCE?

2 13214

what is the name of the default db2 catalog database?

IBM,

3 8557

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

1 5403

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

1 5486

Explain the EXPLAIN statement?

1 4993

Post New DB2 Questions

Un-Answered Questions { DB2 }

Define db2.

1120

How does a cursor work?

994

How do I import a csv file into db2?

995

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2222

What are the benefits of using the db2 database?

1235

What is database manager in db2?

1027

Why db2 is called db2?

1051

What is the max length of sqlca?

1221

Explain what are the various isolation levels possible?

1047

What do you mean by storage group (stogroup)?

1043

What is the connection string to connect to the DB2 Database ?

1136

What are db2 tables?

1131

Which is faster delete or truncate?

1134

What is db2 command?

1043

What is the purpose of using commit?

1103

For More Un-Answered { DB2 } Questions Click Here