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 7321

Can I use LOCK TABLE on a view?

1 6799

Are views updatable ?

4 12362

Give some example of statistics collected during RUNSTATS?

1 5759

What is referential integrity?

5 19741

What is EXPLAIN?

1 6067

What is a DB2 plan?

8 45062

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

2 5812

What is a page?

2 5005

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

CTS,

1 10091

What is a collection?

3 6743

What does the CHECK Utility do ?

1 5546

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

2 5819

What are the various locking levels available?

3 6638

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

3 7273

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is image copy in db2?

944

What is buffer pool in the db2 database?

1046

What is null in db2?

948

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

2278

What is cloudant database?

1033

Name the various locking levels available?

1035

Define sqlca.

1055

What is the reason behind not using select * in embedded sql programs?

1044

What are union and union all?

920

What do you mean by rollback?

932

Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

1310

Which are the db2 tools to protect integrity of the database?

1071

What types of tables are there in the db2 database?

1005

How is a typical db2 batch pgm executed?

1109

What is query_cache_limit?

928

For More Un-Answered { DB2 } Questions Click Here