DB2 Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

DB2 Interview Questions

Questions Answers Views Company eMail

What is a view? Why use it?

3 5298

What is sqlcode -811?

Accenture, CTS, TCS,

7 72103

What is an intent lock?

3 9823

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

1 4129

What is a synonym? How is it used?

2 4802

what is a collection?

2 4543

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

IBM,

1 12609

What are the disadvantages of using VARCHAR?

3 14329

What is the purpose of the DSNC transaction ?

1 6860

What are delete-connected tables?

1 3687

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

4 28895

What is a correlated sub query?

2 4701

What is read-only cursor?

1 6136

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

1 5049

What is Skeleton cursor table (SKCT)?

2 13130

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is the role of union all and union

727

Can one database have multiple instances?

661

Explain correlated sub-queries.

663

When do you specify the isolation level?

687

What is a bind in db2?

679

What is syscat in db2?

661

What does db2 plan contain?

655

What does db2 stand for?

672

Mention the downsides of page level lock.

812

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

828

What is the latest version of ibm db2?

826

What is dbrm? When it will be created?

677

What is bind package and plan in db2?

694

What is plan in cobol db2?

686

Which are the db2 tools to protect integrity of the database?

775

For More Un-Answered { DB2 } Questions Click Here