Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

2073

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 9231

How can you display the current date & current time ?

Cap Gemini,

1 5097

How can you display the current date & current time ?

Cap Gemini,

7 12931

Which one allows duplicate values Union or Union All ?

3 7547

Can you Average the Characters ?

3 6200

What is DCLGEN ?

3 8535

what is SPUFI ?

2 7570

Is Cursor exicutable ?

TetraSoft,

3 8084

Name some fields from SQLCA

1 6133

What do you need to do before you do EXPLAIN ?

1 4922

What are the Isolation levels possible ?

5 7907

what is the soft code for deadlock ?

Logica CMG,

2 6980

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 6192

what are the SQL codes u freequently got?

Logica CMG,

2 7544


Post New DB2 Questions

Un-Answered Questions { DB2 }

What type of database is db2?

975


Explain about mirror activator disk mirroring?

1018


is it compulsory commitment control in journal?

2485


What is dbrm in db2 database?

1128


Are views updateable?

1167


What are foreign keys in db2?

1113


Mention the definition of cobol in varchar field.

1252


What is the advantage in De-normalizing tables in DB2?

1189


How and when does the db2 enforces the unique key?

1089


What is db2 optimizer?

1256


Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1068


Explain the contents that are a part of dclgen.

1096


What is the picture clause of null indicator variable?

1140


What do you mean by cursor?

995


Which isolation level provides highest data integrity?

1130