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 6328

Can I use LOCK TABLE on a view?

1 6223

Are views updatable ?

4 10354

Give some example of statistics collected during RUNSTATS?

1 5184

What is referential integrity?

5 18315

What is EXPLAIN?

1 4951

What is a DB2 plan?

8 42999

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

2 4727

What is a page?

2 4222

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

CTS,

1 9196

What is a collection?

3 5543

What does the CHECK Utility do ?

1 4836

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

2 5021

What are the various locking levels available?

3 5539

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

3 5718

Post New DB2 Questions

Un-Answered Questions { DB2 }

What are packages in db2?

597

Why select is not preferred in embedded sql programs?

715

What is ibm db2 connect?

574

Explain about rct in db2?

640

What parameters are used to control the free space in DB2?

642

What is database manager in db2?

551

What is the physical storage length of time data type?

673

Explain db2.

620

Mention the definition of cobol in varchar field.

700

What does runstats do in db2?

607

What is the role of schema in the db2 database?

653

Can you use max on a char column?

638

What is db2 instance?

592

What is the syntax for creating a table in the db2 database?

628

How do I create a view in db2?

606

For More Un-Answered { DB2 } Questions Click Here