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

2116

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 9350

How can you display the current date & current time ?

Cap Gemini,

1 5167

How can you display the current date & current time ?

Cap Gemini,

7 13133

Which one allows duplicate values Union or Union All ?

3 7643

Can you Average the Characters ?

3 6279

What is DCLGEN ?

3 8642

what is SPUFI ?

2 7650

Is Cursor exicutable ?

TetraSoft,

3 8173

Name some fields from SQLCA

1 6207

What do you need to do before you do EXPLAIN ?

1 4977

What are the Isolation levels possible ?

5 8018

what is the soft code for deadlock ?

Logica CMG,

2 7059

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 6269

what are the SQL codes u freequently got?

Logica CMG,

2 7622

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is the use of db2 optimizer?

1171

What's The Percentage Free Space ?

1280

What are the uses of db2 optimizer?

1350

Is db2 a mainframe?

1093

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

1148

How would you find out the total number of rows in a db2 table?

1094

Are views updateable?

1231

B37 abend during spufi?

1504

What db2 400?

1249

Which command is used to connect to a database in DB2 ? Give the Syntax.

1146

What is the physical storage length of the data types date, time, and timestamp?

1136

Mention the various locks that are available in db2.

1079

How connect db2 database to datastage?

1289

Explain about rct.

1129

What is cloudant database?

1150

For More Un-Answered { DB2 } Questions Click Here