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 7453

Can I use LOCK TABLE on a view?

1 6883

Are views updatable ?

4 12614

Give some example of statistics collected during RUNSTATS?

1 5873

What is referential integrity?

5 19920

What is EXPLAIN?

1 6184

What is a DB2 plan?

8 45390

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

2 5933

What is a page?

2 5103

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

CTS,

1 10187

What is a collection?

3 6921

What does the CHECK Utility do ?

1 5647

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

2 5957

What are the various locking levels available?

3 6767

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

3 7442

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is the meaning concurrency in the db2 database?

1110

How do I change the column size in db2?

1157

How will you return the number of records in table?

937

How many types of page locks can be held in db2?

1040

How can you quickly find out the # of rows updated after an update statement?

1046

What is cursor in dbms?

1066

What is db2 catalog database?

1041

What are the rules for db2 programming?

1087

define clustering index.

1026

List out the three types of page locks that can be held.

1149

What are the 2 sqlcodes that are returned?

1189

How to create db2 table in mainframe?

1154

What is view db2?

1076

What is an instance database?

1052

How do you select a row using indexes in db2?

1135

For More Un-Answered { DB2 } Questions Click Here