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

DB2 Interview Questions

Questions Answers Views Company eMail

What are PACKAGES ?

3 9028

Which catalog tables contain authorization information?

1 6132

Is DECLARE TABLE in DCLGEN necessary? Why it used?

3 9681

How does one remove entries from the SCT02 table?

1 4598

what is the difference between join and union?

IBM,

4 18816

I use CS and update a page. Will the lock be released after I am done with that page?

2 9856

Explain what a plan is?

CTS,

3 8781

What is a synonym ?

2 5632

What are the four lockable units for DB2?

1 6293

In a DB2-CICS program which is acts as co-ordinator and which is participant?

IBM,

1 5407

Describe what a storage group(STOGROUP) is?

2 10359

What is SPUFI?

4 17459

What is the difference between SYNONYM and ALIAS?

TCS,

6 28981

What is a data page?

1 4582

What is a subselect? Is it different from a nested select?

1 7857

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is db2 purescale?

1011

How can we retrieve the total number of records in RPG & CLLE?

656

How can you do the explain of a dynamic sql statement?

1070

What is page size in db2?

979

What is the role of schema in the db2 database?

1278

How to execute stored procedures?

1134

What os does db2 run on?

992

What is alias in db2?

1066

What is the difference between spufi and qmf?

1135

What are the uses of db2 optimizer?

1299

What is the difference between oracle and db2?

1112

What is cursor stability in db2?

1363

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

1134

What is the use of commit in db2?

1083

What's The Error Code For Unique Index Voilation?

1242

For More Un-Answered { DB2 } Questions Click Here