Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

DB2 Interview Questions
Questions Answers Views Company eMail

What information is used as input to the bind process?

2 4997

Can I use LOCK TABLE on a view?

1 5471

Are views updatable ?

4 8515

Give some example of statistics collected during RUNSTATS?

1 4502

What is referential integrity?

5 16547

What is EXPLAIN?

1 3973

What is a DB2 plan?

8 40453

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

2 3822

What is a page?

2 3290

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

CTS,

1 7784

What is a collection?

3 4434

What does the CHECK Utility do ?

1 4080

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

2 4037

What are the various locking levels available?

3 4370

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

3 4210


Post New DB2 Questions






Un-Answered Questions { DB2 }

What is innodb buffer pool?

200


Define check constraint.

260


What is database alias db2?

219


What is db2 and what is the use of db2 optimizer?

206


Which components manage deadlocks in db2?

236






Describe major components of db2?

242


What is blu acceleration in db2?

208


Mention a credible reason why select* is never given preference in an sql program that has been embedded.

272


Are views updateable?

240


is it compulsory commitment control in journal?

1615


Explain db2.

228


How to access db2 tables in mainframe?

206


How do you stop a db2 database in linux?

191


What is multi row fetch in db2?

206


What are db2 tables?

186