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

2021

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 9051

How can you display the current date & current time ?

Cap Gemini,

1 5007

How can you display the current date & current time ?

Cap Gemini,

7 12649

Which one allows duplicate values Union or Union All ?

3 7398

Can you Average the Characters ?

3 6064

What is DCLGEN ?

3 8401

what is SPUFI ?

2 7441

Is Cursor exicutable ?

TetraSoft,

3 7915

Name some fields from SQLCA

1 6054

What do you need to do before you do EXPLAIN ?

1 4846

What are the Isolation levels possible ?

5 7695

what is the soft code for deadlock ?

Logica CMG,

2 6873

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 6089

what are the SQL codes u freequently got?

Logica CMG,

2 7431


Post New DB2 Questions

Un-Answered Questions { DB2 }

How can we retrieve the total number of records in RPG & CLLE?

598


Explain about rct in db2?

1056


What is copy pending and check pending in db2?

967


Explain what are the various isolation levels possible?

1006


What is the function of logging in the db2 database?

1082


What is the difference between using bind () and rebind () methods of naming class?

1347


What is query_cache_limit?

939


DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2800


What is reorg and runstats in db2?

1170


How many databases are there?

1014


How do I add a column to an existing table in db2?

986


What is innodb buffer pool?

999


Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1022


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

1060


What is db2 stogroup?

1113