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 6401

What is sqlcode -811?

Accenture, CTS, TCS,

7 74847

What is an intent lock?

3 10926

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

1 4754

What is a synonym? How is it used?

2 5702

what is a collection?

2 5532

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

IBM,

1 13280

What are the disadvantages of using VARCHAR?

3 15804

What is the purpose of the DSNC transaction ?

1 7663

What are delete-connected tables?

1 4468

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

4 30508

What is a correlated sub query?

2 5580

What is read-only cursor?

1 6851

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

1 5912

What is Skeleton cursor table (SKCT)?

2 14578

Post New DB2 Questions

Un-Answered Questions { DB2 }

What are host variables in db2?

1120

What is ibm db2 connect?

1049

What do you mean by commit and rollback?

1085

What is load replace in db2?

1042

What is dbrm library?

1112

What is the max length of sqlca?

1266

What is the connection string to connect to the DB2 Database ?

1171

What is the difference between using bind () and rebind () methods of naming class?

1451

Can we update view in db2?

1051

What is database alias db2?

1175

Outputs of explain are with matchcols = 0. What does this signify?

1106

How can you find out the # of rows updated after an update statement?

1154

What are concurrency issues?

1169

Is db2 a programming language?

1095

What is scrollable cursor in db2?

1119

For More Un-Answered { DB2 } Questions Click Here