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

2006

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 8994

How can you display the current date & current time ?

Cap Gemini,

1 4989

How can you display the current date & current time ?

Cap Gemini,

7 12577

Which one allows duplicate values Union or Union All ?

3 7363

Can you Average the Characters ?

3 6026

What is DCLGEN ?

3 8371

what is SPUFI ?

2 7410

Is Cursor exicutable ?

TetraSoft,

3 7875

Name some fields from SQLCA

1 6035

What do you need to do before you do EXPLAIN ?

1 4824

What are the Isolation levels possible ?

5 7632

what is the soft code for deadlock ?

Logica CMG,

2 6839

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 6067

what are the SQL codes u freequently got?

Logica CMG,

2 7396

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is the role of union all and union

1069

What is the difference between cursor and select statement?

1052

what is the sqlcode -501

12919

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1049

What types of tables are there in the db2 database?

1005

What is a db2 package?

988

What do you mean by rollback?

932

What is temporal table in db2?

989

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2167

What is the use of runstats in db2?

1022

What is release/acquire in bind?

1057

What are the various data types available in db2?

1012

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

3145

What are the contents of dclgen?

1053

what is utility for parm lib

2309

For More Un-Answered { DB2 } Questions Click Here