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 8337

Which catalog tables contain authorization information?

1 5661

Is DECLARE TABLE in DCLGEN necessary? Why it used?

3 8966

How does one remove entries from the SCT02 table?

1 4191

what is the difference between join and union?

IBM,

4 17779

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

2 9147

Explain what a plan is?

CTS,

3 8036

What is a synonym ?

2 5064

What are the four lockable units for DB2?

1 5840

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

IBM,

1 4908

Describe what a storage group(STOGROUP) is?

2 9733

What is SPUFI?

4 16293

What is the difference between SYNONYM and ALIAS?

TCS,

6 27582

What is a data page?

1 4082

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

1 7192

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is performance tuning db2?

837

Which isolation level provides maximum concurrency?

900

What is the difference between drop table and delete table?

790

What is difference between alias and synonym in db2?

855

Explain packages.

867

ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

1828

Explain in detail about buffer manager and its functionalities?

782

what is diffrence b/w file-aid tool and file-aid utility???

4528

What is the difference between db2 and oracle?

877

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

853

What is the difference between bind and rebind in db2?

1184

Which is faster delete or truncate?

878

What is the reason behind not using select * in embedded sql programs?

845

Give the name of some fields form sqlca.

822

What is commit in db2?

808

For More Un-Answered { DB2 } Questions Click Here