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 9211

How can you display the current date & current time ?

Cap Gemini,

1 5085

How can you display the current date & current time ?

Cap Gemini,

7 12905

Which one allows duplicate values Union or Union All ?

3 7538

Can you Average the Characters ?

3 6180

What is DCLGEN ?

3 8521

what is SPUFI ?

2 7557

Is Cursor exicutable ?

TetraSoft,

3 8063

Name some fields from SQLCA

1 6123

What do you need to do before you do EXPLAIN ?

1 4911

What are the Isolation levels possible ?

5 7873

what is the soft code for deadlock ?

Logica CMG,

2 6967

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 6177

what are the SQL codes u freequently got?

Logica CMG,

2 7528

Post New DB2 Questions

Un-Answered Questions { DB2 }

What are the prerogatives?

1080

List out the buffer pools in db2

1075

What are concurrency issues?

1097

What is a db2 schema?

1233

What is database alias db2?

1127

Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

8292

If I have a view which is a join of two or more tables, can this view be updateable?

1139

What is syscat in db2?

1010

Can we update view in db2?

1003

What is performance tuning db2?

1062

What is reorg?

1161

Mention the definition of cobol in varchar field.

1250

What is difference between alias and synonym in db2?

1143

What are union and union all?

983

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1196

For More Un-Answered { DB2 } Questions Click Here