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 6317

What is sqlcode -811?

Accenture, CTS, TCS,

7 74625

What is an intent lock?

3 10825

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

1 4708

What is a synonym? How is it used?

2 5610

what is a collection?

2 5438

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

IBM,

1 13227

What are the disadvantages of using VARCHAR?

3 15655

What is the purpose of the DSNC transaction ?

1 7592

What are delete-connected tables?

1 4392

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

4 30365

What is a correlated sub query?

2 5476

What is read-only cursor?

1 6785

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

1 5846

What is Skeleton cursor table (SKCT)?

2 14461

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is explain plan in db2?

1006

What is role in db2?

1113

What do you mean by cursor?

994

what are bind concepts in db2 cobol?

1099

What is meant by dclgen?

1116

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

3219

What is the max length of sqlca?

1222

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1112

What is the role of the data page in the db2 database?

1028

How would you find out the total number of rows in a db2 table?

1057

What is with ur in db2?

1327

What is innodb buffer pool?

1063

What is a bind card?

1226

Explain the contents that are a part of dclgen.

1094

How do I create a view in db2?

1029

For More Un-Answered { DB2 } Questions Click Here