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 9013

Which catalog tables contain authorization information?

1 6121

Is DECLARE TABLE in DCLGEN necessary? Why it used?

3 9663

How does one remove entries from the SCT02 table?

1 4579

what is the difference between join and union?

IBM,

4 18785

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

2 9838

Explain what a plan is?

CTS,

3 8758

What is a synonym ?

2 5619

What are the four lockable units for DB2?

1 6267

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

IBM,

1 5398

Describe what a storage group(STOGROUP) is?

2 10339

What is SPUFI?

4 17412

What is the difference between SYNONYM and ALIAS?

TCS,

6 28942

What is a data page?

1 4565

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

1 7843

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is cursor in dbms?

1060

What is db2 and what is the use of db2 optimizer?

1056

Explain dclgen.

1197

What is host variable?

1053

What is the difference between nvl and coalesce?

1059

What is a plan and package in db2?

1095

How can the duplicate values be eliminated from db2 select?

1101

can we view the access paths created by dbrm ? how ? thx

7085

How do I copy a table in db2?

996

What are foreign keys in db2?

1101

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1183

Explain the function done by data manager?

1274

What does sqlcabc has?

1046

Is db2 relational database?

972

How does a cursor work?

982

For More Un-Answered { DB2 } Questions Click Here