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

2065

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 9190

How can you display the current date & current time ?

Cap Gemini,

1 5076

How can you display the current date & current time ?

Cap Gemini,

7 12877

Which one allows duplicate values Union or Union All ?

3 7528

Can you Average the Characters ?

3 6172

What is DCLGEN ?

3 8517

what is SPUFI ?

2 7550

Is Cursor exicutable ?

TetraSoft,

3 8047

Name some fields from SQLCA

1 6115

What do you need to do before you do EXPLAIN ?

1 4905

What are the Isolation levels possible ?

5 7853

what is the soft code for deadlock ?

Logica CMG,

2 6956

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 6169

what are the SQL codes u freequently got?

Logica CMG,

2 7520

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is meant by explain?

1125

Explain the function done by data manager?

1274

What is db2 bind process?

1236

What is the latest version of ibm db2?

1264

What is cursor in dbms?

1060

What is query_cache_limit?

968

Comment whether the cursor is closed during commit or not.

1097

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

1087

What is db2? Explain.

1039

How many databases can be created inside an instance in db2 ?

1029

Mention the different locking levels that are available in db2.

1127

What is deadlock in db2?

1062

What r the comman abends in db2, jcl and cobol???????

2250

What is db2?

1175

What is the maximum No of rows per page?

1065

For More Un-Answered { DB2 } Questions Click Here