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 9200

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 12903

Which one allows duplicate values Union or Union All ?

3 7537

Can you Average the Characters ?

3 6179

What is DCLGEN ?

3 8520

what is SPUFI ?

2 7556

Is Cursor exicutable ?

TetraSoft,

3 8059

Name some fields from SQLCA

1 6120

What do you need to do before you do EXPLAIN ?

1 4911

What are the Isolation levels possible ?

5 7867

what is the soft code for deadlock ?

Logica CMG,

2 6965

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 }

What is db2 command?

1036

What is dbrm? What it contains?

1163

Can we update view in db2?

1002

What is the difference between cursor and select statement?

1101

Name the various locking levels available?

1092

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

2253

What does db2 stand for?

1025

How can we read records for specific member in CL? AND rpg?

700

What is null indicator in cobol db2?

1066

what is a corelated subquerry?

1122

what are bind concepts in db2 cobol?

1092

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

1035

What is dclgen in db2?

1148

How does a cursor work?

985

What is page size in db2?

974

For More Un-Answered { DB2 } Questions Click Here