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 7532

Can I use LOCK TABLE on a view?

1 6938

Are views updatable ?

4 12815

Give some example of statistics collected during RUNSTATS?

1 5939

What is referential integrity?

5 20088

What is EXPLAIN?

1 6236

What is a DB2 plan?

8 45645

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

2 6009

What is a page?

2 5205

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

CTS,

1 10254

What is a collection?

3 7041

What does the CHECK Utility do ?

1 5725

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

2 6048

What are the various locking levels available?

3 6876

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

3 7561

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is the maximum number of columns in a db2 table?

1342

What is db2 connect?

1122

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2261

How is deadlock resolved?

1195

What does db2 blu stand for?

1213

How is the value function used?

1202

What do you mean by between and in? Is between inclusive of specified range values?

1139

What are the contents of dclgen?

1159

What is the maximum length of sqlca?

1605

Explain db2.

1083

Is db2 a mainframe database?

1043

How to find the number of rows in db2 tables?

1125

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1133

Explain about rct in db2?

1160

Define db2.

1165

For More Un-Answered { DB2 } Questions Click Here