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

Two Methods of retrieving SQL?

7 Answers   Atiric Software, Microsoft, Oracle, TCS, Wipro,

---

What are the sql commands?

0 Answers  

---

What is union and union all keyword in sql?

0 Answers  

---

what are the differences between char and nchar? : Sql dba

0 Answers  

---

What are the types of triggers ?

26 Answers   Aspire, BirlaSoft, TCS,

---

Write one update command to update seqno field of a table on the basis of row number.

4 Answers   HCL,

---

What is nvarchar in sql?

0 Answers  

---

What does where 1 1 mean in sql?

0 Answers  

---

write a query to find out the no. of employees whose age is less than 25 and max of salary for the employees belonging to a particular department is less than 20000

6 Answers  

---

3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);

1 Answers   Fintellix,

---

select 10 from dual; y its showing all the rows with 10?

1 Answers  

---

What is difference between pl and sql?

0 Answers  

---