1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category
DB2 Interview Questions
Questions Answers Views Company eMail

What is a view? Why use it?

 3 5052

What is sqlcode -811?

Accenture, CTS, TCS,

7 71319

What is an intent lock?

 3 9508

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

 1 3984

What is a synonym? How is it used?

 2 4604

what is a collection?

 2 4342

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

IBM,

1 12473

What are the disadvantages of using VARCHAR?

 3 14081

What is the purpose of the DSNC transaction ?

 1 6710

What are delete-connected tables?

 1 3557

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

 4 28536

What is a correlated sub query?

 2 4518

What is read-only cursor?

 1 5982

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

 1 4894

What is Skeleton cursor table (SKCT)?

 2 12726

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is the function of logging in the db2 database?

645

What is a system catalog table in db2?

588

What is universal database?

619

What is dbrm? When it will be created?

600

What is the role of schema in the db2 database?

653




DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2278

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

624

List down the data types in the db2 database.

635

What is the use of commit in db2?

634

Which component is responsible for db2 startup and shutdown?

630

Why do we bind in db2?

631

What are db2 tables?

649

is it compulsory commitment control in journal?

2013

How do you find the maximum value in a column in db2?

650

What is difference between isnull and coalesce?

620

For More Un-Answered { DB2 } Questions Click Here