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

DB2 Interview Questions

Questions Answers Views Company eMail

What information is used as input to the bind process?

2 6280

Can I use LOCK TABLE on a view?

1 6207

Are views updatable ?

4 10262

Give some example of statistics collected during RUNSTATS?

1 5168

What is referential integrity?

5 18262

What is EXPLAIN?

1 4896

What is a DB2 plan?

8 42926

How to define the data items to receive the fetch items for the SQL?

2 4691

What is a page?

2 4196

What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?

CTS,

1 9167

What is a collection?

3 5519

What does the CHECK Utility do ?

1 4816

Where could you look if you had a question about whether a column has been defined as an index?

2 4990

What are the various locking levels available?

3 5508

If I have a view which is a join of two or more tables, can this view be updatable?

3 5655

Post New DB2 Questions

Un-Answered Questions { DB2 }

Which command is used to remove all rows from a table?

542

What is a Foreign Key?

646

What do you mean by rollback?

562

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

735

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

606

How can you classify the locks in db2?

624

Explain in detail about buffer manager and its functionalities?

551

What is a buffer in memory?

587

How is the value function used?

595

Explain in brief how does db2 determine what lock-size to use?

585

Explain about rct.

639

Which is faster delete or truncate?

665

What is copy pending and check pending in db2?

567

What is rebind in db2?

567

What is consistency token in db2?

626

For More Un-Answered { DB2 } Questions Click Here