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 Datapump & export/import?

2 Answers  

---

What background process refreshes materialized views?

2 Answers   Accenture, FLSmidth,

---

what is a user-defined lock?

0 Answers   Oracle,

---

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  

---

---

how can you find out if a table can be redefined?

0 Answers   Oracle,

---

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

0 Answers  

---

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

0 Answers  

---

what is the use of home directory???

1 Answers   HP,

---

What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers   STC,

---

How would you go about generating an EXPLAIN plan?

2 Answers  

---

how can you generate profile of pl/sql applications to identify performance bottlenecks?

0 Answers   Oracle,

---