Answer / manjiri

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

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

0 Answers  

---

Which environment variables are absolutely critical in order to run the OUI?

2 Answers  

---

How would you go about generating an EXPLAIN plan?

2 Answers  

---

how can you communicate with operating system files from oracle?

0 Answers   Oracle,

---

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

0 Answers  

---

What are the steps you will take to improve performance of a poor performing query?

0 Answers  

---

i had backup last manday.now i need back monday to now ..how do get backup?

3 Answers   Infozech, Wipro,

---

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

0 Answers   Oracle,

---

Explain the use of table functions.

1 Answers  

---

What would you use to improve performance on an insert statement that places millions of rows into that table?

2 Answers   TCS,

---

what is the difference between hot backup n rman backup?

1 Answers   Value Labs,

---

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  

---