DB2 Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

DB2 Interview Questions

Questions Answers Views Company eMail

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

2070

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

Mphasis,

4 9197

How can you display the current date & current time ?

Cap Gemini,

1 5084

How can you display the current date & current time ?

Cap Gemini,

7 12902

Which one allows duplicate values Union or Union All ?

3 7537

Can you Average the Characters ?

3 6178

What is DCLGEN ?

3 8519

what is SPUFI ?

2 7555

Is Cursor exicutable ?

TetraSoft,

3 8057

Name some fields from SQLCA

1 6118

What do you need to do before you do EXPLAIN ?

1 4911

What are the Isolation levels possible ?

5 7863

what is the soft code for deadlock ?

Logica CMG,

2 6964

the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1

Logica CMG,

2 6173

what are the SQL codes u freequently got?

Logica CMG,

2 7526

Post New DB2 Questions

Un-Answered Questions { DB2 }

Explain the function done by data manager?

1280

What is the use of runstats in db2?

1109

What is db2 purescale?

996

What is the difference between plan and package in db2?

1112

How can you find out the # of rows updated after an update statement?

1116

On which levels locks can be applied?

1130

What are the different types of base tables?

1092

Name the lockable units in DB2?

1128

what is a corelated subquerry?

1122

What are the various data types available in db2?

1094

What is temporal table in db2?

1039

How does db2 sample database connect?

1029

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 default page size of buffer pools?

1122

What does runstats do in db2?

1117

For More Un-Answered { DB2 } Questions Click Here