Sign Up Login


  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

What are the different sql server versions you have worked on? : sql server DBA

0 Answers  

Can we take incremental backups in datapump?

1 Answers  

What questions might be they ask in managerial round in capgemini.

1 Answers   Cap Gemini, iGate,

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  

who owns the operating system files created by the utl_file package?

0 Answers   Oracle,

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

0 Answers  

How would you begin to troubleshoot an ORA-3113 error?

1 Answers  

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

0 Answers  

From the database level, how can you tell under which time zone a database is operating?

1 Answers  

How would you determine what sessions are connected and what resources they are waiting for?

2 Answers  

why do we give pctfree and pctused in create table statement?

1 Answers   CTS,

How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

4 Answers  

For more DB Administration Interview Questions Click Here
Categories