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

Types of cursor locks and explanation each of them ?

3 Answers   DELL, HP Finsoft,

---

write a query filter the null value data following source? name age john 30 smith null null 24 sharp 35 i want output name age john 30 sharp 35

1 Answers   TCS,

---

What is clause?

0 Answers  

---

What is db journal file?

0 Answers  

---

how to convert numeric values to character strings? : Sql dba

0 Answers  

---

what are aggregate and scalar functions? : Sql dba

0 Answers  

---

How do you write an index?

0 Answers  

---

List the various privileges that a user can grant to another user?

0 Answers  

---

What is a table?

0 Answers  

---

Suppose There is a string A.B....C.......D.........E........F In this string dots (.) are not having fixed count in between of string. I want the output to have string with one dot between. I.e. A.B.C.D.E.F

6 Answers   IBM,

---

Is pl sql better than sql?

0 Answers  

---

Difference between inline query and stored procedure?

4 Answers   Bharat, Microsoft,

---