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 6124

Is DECLARE TABLE in DCLGEN necessary? Why it used?

3 9671

How does one remove entries from the SCT02 table?

1 4587

what is the difference between join and union?

IBM,

4 18806

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

2 9846

Explain what a plan is?

CTS,

3 8763

What is a synonym ?

2 5622

What are the four lockable units for DB2?

1 6286

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

IBM,

1 5404

Describe what a storage group(STOGROUP) is?

2 10350

What is SPUFI?

4 17441

What is the difference between SYNONYM and ALIAS?

TCS,

6 28963

What is a data page?

1 4574

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

1 7849

Post New DB2 Questions

Un-Answered Questions { DB2 }

My sql statement select avg(salary) from emp yields inaccurate results. Why?

1092

What are the full forms of spufi and dclgen and why are they used?

1087

What is null value in db2?

1024

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

2065

What is the max length of sqlca?

1216

What is reorg?

1160

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

2388

Is the primary key a clustered index?

1149

What is the syntax for FETCH in DB2 ?

1212

Mention the various locks that are available in db2.

1039

What is deadlock in db2?

1069

What is cursor in dbms?

1064

How do we specify index to include or not during bind process.

2126

What is db2 bind?

1082

What is the latest version of ibm db2?

1269

For More Un-Answered { DB2 } Questions Click Here