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 5613

What is sqlcode -811?

Accenture, CTS, TCS,

7 72815

What is an intent lock?

3 10133

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

1 4290

What is a synonym? How is it used?

2 5063

what is a collection?

2 4780

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

IBM,

1 12792

What are the disadvantages of using VARCHAR?

3 14639

What is the purpose of the DSNC transaction ?

1 7053

What are delete-connected tables?

1 3898

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

4 29351

What is a correlated sub query?

2 4886

What is read-only cursor?

1 6320

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

1 5326

What is Skeleton cursor table (SKCT)?

2 13617

Post New DB2 Questions

Un-Answered Questions { DB2 }

Explain correlated sub-queries.

773

What is a db2 package?

789

Explain the contents that are a part of dclgen.

873

i want to maintain uniqueness on pdf without make lf??????????

1904

What is cursor in dbms?

838

is it compulsory commitment control in journal?

2223

How do we specify index to include or not during bind process.

1860

What is the syntax for FETCH in DB2 ?

917

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

850

What is db2 stogroup?

893

What is the max length of sqlca?

963

How do you select a row using indexes in db2?

845

What is dbrm?

857

Can you tell me how can you find out the # of rows updated after an update statement?

863

Is ibm db2 free?

762

For More Un-Answered { DB2 } Questions Click Here