DB2 Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

DB2 Interview Questions

Questions Answers Views Company eMail

What are foreign keys in db2?

1168

Describe major components of db2?

1141

Explain about rct in db2?

1160

What is db2?

1229

Explain various types of locks in db2?

1204

What is the use of db2 optimizer?

1171

What are the full forms of spufi and dclgen and why are they used?

1136

Give a brief description of db2 isolation levels?

1133

What is db2 and what is the use of db2 optimizer?

1108

Mention data types used in db2 ?

1198

Explain the contention situations caused by locks?

1139

What is buffer pool and list some of them?

1090

Mention and explain the contention situations caused by locks?

1 1574

What is meant by union and union all?

1051

Explain package in db2 and its advantages?

1269

Post New DB2 Questions

Un-Answered Questions { DB2 }

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1127

Comment whether the cursor is closed during commit or not.

1167

can all users have the privilage to use the sql statement select * (dml)?

1219

What are the various isolation levels possible?

1177

What is dbrm? What it contains?

1211

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

1117

What is a dbrm in db2?

1075

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

3202

What happens in bind step in a db2 program?

1009

How to rename a table in DB2 ?

1142

How do I create a view in db2?

1073

What is db2 catalog database?

1087

What is difference between alias and synonym in db2?

1193

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1240

Can we update view in db2?

1051

For More Un-Answered { DB2 } Questions Click Here