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...

  1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

Is it possible to update the multiple field values in a
single query? If possible then write the actual query.

Question Posted / arup.imp


Is it possible to update the multiple field values in a single query? If possible then write the ac..

Answer / manjiri

update table_name
set col1=new_value, col2= new_value...
where condition/'s

Is This Answer Correct ?    14 Yes 1 No

Post New Answer

More DB Administration Interview Questions

Where would you look for errors from the database engine?

0 Answers   IBM,

What is a system database and what is a user database? : sql server DBA

0 Answers  

what r the types of backup?

5 Answers   CSC,

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

3 Answers  

What are the different types of database compression introduced in sql server 2008? : sql server DBA

0 Answers  

what is the difference between catalog & nocatalog?

3 Answers   CSC,

What view would you use to determine free space in a tablespace?

3 Answers  

deleted of control file how will u recover control file?

4 Answers   CTS,

What command would you use to encrypt a PL/SQL application?

1 Answers  

Can you take Online Backups if the the database is running in NOARCHIVELOG mode? 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?

11 Answers   FA, GE, Wipro,

what is a user-defined lock?

0 Answers   Oracle,

How do you switch from an init.ora file to a spfile?

4 Answers   TCS,

For more DB Administration Interview Questions Click Here
Categories