DB2 Interview Questions
Questions Answers Views Company eMail

What is a view? Why use it?

3 5074

What is sqlcode -811?

Accenture, CTS, TCS,

7 71378

What is an intent lock?

3 9525

what types of copies can be made with the COPY Utility ?

1 3993

What is a synonym? How is it used?

2 4615

what is a collection?

2 4353

What is the difference between TYPE 1 index & TYPE 2 index

IBM,

1 12482

What are the disadvantages of using VARCHAR?

3 14088

What is the purpose of the DSNC transaction ?

1 6718

What are delete-connected tables?

1 3567

What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?

4 28562

What is a correlated sub query?

2 4542

What is read-only cursor?

1 5994

What Utility is used to migrate DB2 from one release to the next?

1 4909

What is Skeleton cursor table (SKCT)?

2 12753


Post New DB2 Questions

Un-Answered Questions { DB2 }

What os does db2 run on?

578


What is buffer pool in the db2 database?

625


What is dpf in db2?

672


If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

710


Explain the function of data manager.

637






When the like statement is used?

642


What does db2 plan contain?

576


What is a collection in db2?

585


How to create db2 table in mainframe?

639


B37 abend during spufi?

988


What are the various isolation levels possible?

653


What is reorg?

624


What is null in db2?

579


is it compulsory commitment control in journal?

2016


Differentiate between cs and rr isolation levels? Where do you specify them?

591