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 6128

Is DECLARE TABLE in DCLGEN necessary? Why it used?

3 9678

How does one remove entries from the SCT02 table?

1 4592

what is the difference between join and union?

IBM,

4 18807

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

2 9849

Explain what a plan is?

CTS,

3 8766

What is a synonym ?

2 5623

What are the four lockable units for DB2?

1 6290

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 10356

What is SPUFI?

4 17446

What is the difference between SYNONYM and ALIAS?

TCS,

6 28964

What is a data page?

1 4574

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

1 7851

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is db2?

1182

What is difference between rollback and commit?

1159

Explain package in db2 and its advantages?

1219

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

1128

How to retrieve rows from a db2 table in embedded sql?

1390

Differentiate between cs and rr isolation levels? Where do you specify them?

1071

What is load utility in db2?

1181

What's The Percentage Free Space ?

1224

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

1068

What is cursor with hold option in db2?

1073

What is the difference between spufi and qmf?

1132

What is reorg and runstats in db2?

1219

What does sqlcabc has?

1054

Define sqlca.

1112

What is a db2 tablespace?

1065

For More Un-Answered { DB2 } Questions Click Here