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 6287

What is sqlcode -811?

Accenture, CTS, TCS,

7 74575

What is an intent lock?

3 10805

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

1 4695

What is a synonym? How is it used?

2 5596

what is a collection?

2 5404

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

IBM,

1 13208

What are the disadvantages of using VARCHAR?

3 15627

What is the purpose of the DSNC transaction ?

1 7580

What are delete-connected tables?

1 4375

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

4 30329

What is a correlated sub query?

2 5456

What is read-only cursor?

1 6764

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

1 5830

What is Skeleton cursor table (SKCT)?

2 14432

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is the difference between drop table and delete table?

1203

What is the max length of sqlca?

1214

Before you give the explain statement, what are the prerogatives?

1028

What is bind plan?

1044

What is bind in db2?

1037

How to find primary key of a table in db2?

1061

How do you stop a db2 database in linux?

1009

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3152

How can record locking be achieved in those DB2 versions which do not support it?

1073

Is it possible using max on a char column?

1135

What is package in db2 mainframe?

984

What are the benefits of using the db2 database?

1224

How to get the ddl of a table in db2?

1127

What is the cobol picture clause of the db2 data types date, time, timestamp?

1058

Explain about rct in db2?

1104

For More Un-Answered { DB2 } Questions Click Here