Answer / santosh kumar

1.Threads share the address space of the process that created it; processes have their own address.

2.Threads have direct access to the data segment of its process; processes have their own copy of the data segment of the parent process.

3.Threads can directly communicate with other threads of its process; processes must use interprocess communication to communicate with sibling processes.

4.Threads have almost no overhead; processes have considerable overhead.

5.New threads are easily created; new processes require duplication of the parent process.

6.Threads can exercise considerable control over threads of the same process; processes can only exercise control over child processes.

7.Changes to the main thread (cancellation, priority change, etc.) may affect the behavior of the other threads of the process; changes to the parent process does not affect child processes.

what do you understand by flashback feature of oracle?

0 Answers   Oracle,

---

How do you tell what your machine name is and what is its IP address?

4 Answers  

---

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1 Answers  

---

If CPU is very slow What can u do to speed up?

1 Answers  

---

Hot backup procedure?

2 Answers  

---

What is the dataguard background process??

1 Answers   iGate,

---

Where would you look for errors from the database engine?

0 Answers   IBM,

---

how does an oracle clusterware manage crs resources?

0 Answers   Oracle,

---

How would you go about generating an EXPLAIN plan?

2 Answers  

---

what is the purpose of catlaog in oracle rman?

2 Answers   Value Labs,

---

What does coalescing a tablespace do?

1 Answers  

---

How would you go about increasing the buffer cache hit ratio?

2 Answers  

---