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 6299

What is sqlcode -811?

Accenture, CTS, TCS,

7 74587

What is an intent lock?

3 10809

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

1 4695

What is a synonym? How is it used?

2 5602

what is a collection?

2 5415

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

IBM,

1 13218

What are the disadvantages of using VARCHAR?

3 15640

What is the purpose of the DSNC transaction ?

1 7584

What are delete-connected tables?

1 4376

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

4 30340

What is a correlated sub query?

2 5460

What is read-only cursor?

1 6774

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

1 5834

What is Skeleton cursor table (SKCT)?

2 14437

Post New DB2 Questions

Un-Answered Questions { DB2 }

What are the two types of logging in the db2 database? Explain them.

1073

What do you mean by commit and rollback?

1038

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

2155

What is the difference between cursor stability and repeatable read isolation levels?

1173

What is db2 catalog database?

1041

Explain what are the various isolation levels possible?

1044

Explain about dbrm.

1047

What is a plan and package in db2?

1101

Why do we need reorg in db2?

985

What is null indicator in cobol db2?

1065

What are the prerogatives?

1080

What is sqlca’s maximum length?

1183

What is db2 stogroup?

1160

What is performance tuning db2?

1061

Which component is responsible for processing sql statements and selecting access paths?

1127

For More Un-Answered { DB2 } Questions Click Here