Answer / rahul khanke

hi,
basic oracle architecture is devided in 3 stages
1. storage structure
1. physical storage
a. data file
b. control file etc..
2.logical storage
a. tablespace
b. extents etc..
2. memory structure
a. SGA
b. PGA
2. process structure
1. mandatory process
a. SMON
b. PMON etc
2. optional process

and much more

Find out the 3rd highest salary?

51 Answers   BirlaSoft, DAC, Silvia Infotech, Sutra Infotech,

---

What is constant in pl sql?

0 Answers  

---

What are the new features in Oracle 10g. Compared to Oracle 9i?

1 Answers   Polaris,

---

How will you select unique values from a list of records?

7 Answers   Cap Gemini,

---

Can we call stored procedure in function?

0 Answers  

---

Is ms sql traffic encrypted?

0 Answers  

---

what are the differences between require and include, include_once and require_once? : Sql dba

0 Answers  

---

How do I partition a table in sql?

0 Answers  

---

What is sql deadlock?

0 Answers  

---

What does count (*) do in sql?

0 Answers  

---

I have a tablle like this. cust acc --------------- a 1 b 2|3 c 4|5|6 I Want below o/p: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 Please any one can you have any ideas share me. I have urgent requirement.

4 Answers   Cap Gemini, MTS,

---

what is organisational index?

1 Answers  

---