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 7446

Can I use LOCK TABLE on a view?

1 6878

Are views updatable ?

4 12594

Give some example of statistics collected during RUNSTATS?

1 5866

What is referential integrity?

5 19915

What is EXPLAIN?

1 6181

What is a DB2 plan?

8 45366

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

2 5928

What is a page?

2 5098

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

CTS,

1 10176

What is a collection?

3 6910

What does the CHECK Utility do ?

1 5642

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

2 5949

What are the various locking levels available?

3 6766

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

3 7432

Post New DB2 Questions

Un-Answered Questions { DB2 }

How many databases are there?

1051

What is db2 catalog database?

1038

What is data manager?

1046

Explain about mirror activator disk mirroring?

1004

Define predicate?

1127

What is the clustering index in the db2 database?

1001

What type of database is db2?

965

Are views updateable?

1150

What is dbrm library?

1048

What is rebind in db2?

1052

How do I create a view in db2?

1018

What kind of database is db2?

1031

What are the contents of a dclmgen?

1122

What is buffer pool?

1093

What is a system catalog table in db2?

1184

For More Un-Answered { DB2 } Questions Click Here