Answer Posted / 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

What has stored procedures in sql?

992

---

What is compilation error in pl sql?

920

---

What does data normalization mean?

897

---

Is a foreign key always unique?

883

---

How to process query result in pl/sql?

1060

---

What is the plv (pl/vision) package offers?

981

---

Is ms sql traffic encrypted?

872

---

Is microsoft sql free?

1043

---

Write the command to remove all players named sachin from the players table.

1121

---

What is the difference between distinct and unique in sql?

873

---

what are date and time data types? : Sql dba

930

---

Can a trigger call a stored procedure?

1001

---

Can you inner join the same table?

934

---

What is posting?

990

---

What are the types of variables use in pl sql?

969

---