What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

1 Answers  

---

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1 Answers  

---

What is the difference between online backup & offline backup?

3 Answers   CSC,

---

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers  

---

Explain how you would restore a database using RMAN to Point in Time?

1 Answers  

---

---

What's the benefit of "dbms_stats" over "analyze"?

1 Answers  

---

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

0 Answers  

---

what is the purpose of catlaog in oracle rman?

2 Answers   Value Labs,

---

i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???

1 Answers   iGate,

---

Give the reasoning behind using an index.

2 Answers  

---

Explain the concept of the DUAL table.

3 Answers  

---

how can you process messages in order asynchronously?

0 Answers   Oracle,

---