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.

i need a brief information about db2 dba course and realtime experts if any plz inform me nareshbhupathi93@gmail.com plzzz urgent

1 Answers   TCS,

---

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

0 Answers  

---

What is the default fill factor value? : sql server DBA

0 Answers  

---

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

1 Answers  

---

What would you do with an "in-doubt" distributed transaction?

0 Answers  

---

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 Answers  

---

Give two examples of how you might determine the structure of the table DEPT.

2 Answers  

---

which background process will run @ the time of creation of catalog database

1 Answers   CSC,

---

Explain materialized views and how they are used.

0 Answers  

---

How would you go about generating an EXPLAIN plan?

2 Answers  

---

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

1 Answers   IBM,

---

What are the commands you'd issue to show the explain plan for "select * from dual"?

0 Answers  

---