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.

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

2 Answers  

---

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

0 Answers   Oracle,

---

From the database level, how can you tell under which time zone a database is operating?

1 Answers  

---

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

1 Answers   STC,

---

What type of index should you use on a fact table?

1 Answers  

---

Is it possible to update the multiple field values in a single query? If possible then write the actual query.

1 Answers   Oracle,

---

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1 Answers  

---

What is the importance of a recovery model? : sql server DBA

0 Answers  

---

what is ora 24313?what is the procedure to exclude that error?

0 Answers  

---

Explain what partitioning is and what its benefit is.

2 Answers  

---

Compare and contrast TRUNCATE and DELETE for a table.

7 Answers  

---

What background process refreshes materialized views?

2 Answers   Accenture, FLSmidth,

---