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

Which query operators in sql is used for pattern matching?

957

---

what is union? : Sql dba

1022

---

what is log shipping? : Sql dba

1104

---

What are the different dcl commands in sql?

1146

---

Can we join two tables without common column?

999

---

does sql support programming? : Sql dba

1035

---

how can we destroy the cookie? : Sql dba

1007

---

How much does sql cost?

992

---

Explain the difference between triggers and constraints?

967

---

What is the use of prepared statement?

1007

---

how to load data files into tables with 'mysqlimport'? : Sql dba

1091

---

differentiate between float and double. : Sql dba

1051

---

how to create a new table in mysql? : Sql dba

983

---

What is a constraint? Tell me about its various levels.

1156

---

what does the t-sql command ident_incr does? : Transact sql

1071

---