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 9109

Which catalog tables contain authorization information?

1 6211

Is DECLARE TABLE in DCLGEN necessary? Why it used?

3 9776

How does one remove entries from the SCT02 table?

1 4664

what is the difference between join and union?

IBM,

4 18975

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

2 9951

Explain what a plan is?

CTS,

3 8886

What is a synonym ?

2 5736

What are the four lockable units for DB2?

1 6373

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

IBM,

1 5471

Describe what a storage group(STOGROUP) is?

2 10448

What is SPUFI?

4 17615

What is the difference between SYNONYM and ALIAS?

TCS,

6 29163

What is a data page?

1 4636

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

1 7964

Post New DB2 Questions

Un-Answered Questions { DB2 }

When the like statement is used?

1278

Highlight all the advantages that are attached to a package.

1169

What is a plan and package in db2?

1150

What do you mean by cursor?

1029

What is a db2 schema?

1294

Define buffer pool.

1097

What is sqlca?

1128

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

2290

What is with ur in db2?

1382

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

1127

How connect db2 database to datastage?

1289

Why do chiropractors use drop table?

1160

What are iseries servers?

1126

Explain in brief how does db2 determine what lock-size to use?

1085

What is a bind card?

1274

For More Un-Answered { DB2 } Questions Click Here