Is it possible to update the multiple field values in a
single query? If possible then write the actual query.
Answer / manjiri
update table_name
set col1=new_value, col2= new_value...
where condition/'s
Is This Answer Correct ? | 14 Yes | 1 No |
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
What is checkpoint?
SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.
How would you begin to troubleshoot an ORA-3113 error?
Explain about your sql server dba experience? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What authentication modes does sql server support? : sql server DBA
how can you record information about current session?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
How do you trace the traffic hitting a sql server? : sql server DBA
What is the difference between clustered and non-clustered index? : sql server DBA
what functionality does oracle provide to secure sensitive information?