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.

If we issue alter database begin backup. What happens to database?

2 Answers  

---

How can you enable a trace for a session?

1 Answers  

---

When creating a user, what permissions must you grant to allow them to connect to the database?

3 Answers  

---

What happens on checkpoint? : sql server DBA

0 Answers  

---

What are the different types of database compression introduced in sql server 2008? : sql server DBA

0 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  

---

Explain about your sql server dba experience? : sql server DBA

0 Answers  

---

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

0 Answers  

---

Name two files used for network connection to a database.

5 Answers  

---

How do you resize a data file?

2 Answers  

---

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   IBM,

---

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

0 Answers  

---