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

How will you debug your procedure? If your procedure is around 2000 lines and the expected output is 10 and we get only output 5.So how will you debug it? Somebody pls give the correct answer?

2 Answers   Fidelity,

---

Regarding joins what are the differences you observed in oracle 9i and sql server?

3 Answers   Choice Solutions,

---

Inline the values in PL/SQL, what does it mean.?

0 Answers   MCN Solutions,

---

how to retrive only second row from table?

31 Answers   IBM,

---

How do I find duplicates in two columns?

0 Answers  

---

what is oltp (online transaction processing)? : Sql dba

0 Answers  

---

What is ON DELETE CASCADE?

3 Answers  

---

What do you understand by exception handling in pl/sql?

0 Answers  

---

What will be the output of the following String S = 1+2+"abc" S = ? String S1 = 1+2+"abc"+5+6 S1 = ?

1 Answers   ABC,

---

How we can update the view?

0 Answers  

---

What does data normalization mean?

0 Answers  

---

Can I create table without primary key?

0 Answers  

---