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.

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 Answers   IBM,

---

Give the two types of tables involved in producing a star schema and the type of data theyhold.

2 Answers  

---

internal architecture

0 Answers   CSC,

---

What does coalescing a tablespace do?

1 Answers  

---

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

0 Answers  

---

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

1 Answers  

---

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

0 Answers   IBM,

---

How do you add a data file to a tablespace?

3 Answers  

---

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

5 Answers  

---

What is transparent data encryption? : sql server DBA

0 Answers  

---

what is a crs resource?

0 Answers   Oracle,

---

What is dbcc? : sql server DBA

0 Answers  

---