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 9016

Which catalog tables contain authorization information?

1 6123

Is DECLARE TABLE in DCLGEN necessary? Why it used?

3 9671

How does one remove entries from the SCT02 table?

1 4583

what is the difference between join and union?

IBM,

4 18796

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

2 9842

Explain what a plan is?

CTS,

3 8763

What is a synonym ?

2 5621

What are the four lockable units for DB2?

1 6279

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

IBM,

1 5400

Describe what a storage group(STOGROUP) is?

2 10350

What is SPUFI?

4 17432

What is the difference between SYNONYM and ALIAS?

TCS,

6 28961

What is a data page?

1 4572

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

1 7848

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is a db2 package?

1053

What is netezza database?

1025

What os does db2 run on?

980

How do I add a column to a table in db2?

1104

What are the rules for db2 programming?

1087

What is bufferpool in db2?

1052

Explain db2.

1033

What does sqlcabc has?

1053

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2849

What is db2 bind process?

1236

Is db2 a mainframe?

1043

How do I connect my db2 database to ibm?

1048

List out the buffer pools in db2

1073

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

3152

What is consistency token in db2?

1141

For More Un-Answered { DB2 } Questions Click Here