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 8874

Which catalog tables contain authorization information?

1 6003

Is DECLARE TABLE in DCLGEN necessary? Why it used?

3 9497

How does one remove entries from the SCT02 table?

1 4497

what is the difference between join and union?

IBM,

4 18583

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

2 9687

Explain what a plan is?

CTS,

3 8616

What is a synonym ?

2 5467

What are the four lockable units for DB2?

1 6188

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

IBM,

1 5300

Describe what a storage group(STOGROUP) is?

2 10200

What is SPUFI?

4 17201

What is the difference between SYNONYM and ALIAS?

TCS,

6 28644

What is a data page?

1 4474

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

1 7721

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is the difference between spufi and qmf?

1053

What is the purpose of rollback and commit?

1085

What is a plan and package in db2?

1043

What is check constraint. Explain with example.

1043

How do you stop a db2 database in linux?

957

Before you give the explain statement, what are the prerogatives?

969

What is explain in db2?

958

What is plan in cobol db2?

1059

What is isolation level in db2?

941

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1048

What are db2 tables?

1049

What is syscat in db2?

950

What is multi row fetch in db2?

985

What is cobol db2?

933

What is with ur in db2?

1242

For More Un-Answered { DB2 } Questions Click Here