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 4220

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

IBM,

1 4282

How does DB2 use multiple table indexes?

1 4982

What is meant by repeatable read?

4 8766

Compare a subselect to a join?

1 4097

Describe the elements of the SELECT query syntax?

3 5160

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

IBM,

2 8381

What is the FREE command?

1 4321

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

2258

What is DB2 (IBM Database 2)?

3 4335

What is QUIESCE?

2 12148

what is the name of the default db2 catalog database?

IBM,

3 7237

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

1 4604

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

1 4671

Explain the EXPLAIN statement?

1 4219

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is cloudant database?

636

What is the use of commit in db2?

621

What is runstats and reorg in db2?

775

What is the information associated with sysibm.syslinks table?

644

How to find the number of rows in a db2 table?

638

What is buffer pool in the db2 database?

600

What is host variable in db2 cobol?

585

What is buffer pool and list some of them?

617

Why do chiropractors use drop table?

645

How to create db2 table in mainframe?

615

How to get the ddl of a table in db2?

662

Give a brief description of db2 isolation levels?

587

what is the sqlcode -501

11223

What is the use of dclgen in db2?

578

Which component is responsible for db2 startup and shutdown?

615

For More Un-Answered { DB2 } Questions Click Here