Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

please explain database architecture..

Question Posted / neelima.gg


please explain database architecture.. ..

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

Is This Answer Correct ?    8 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

what is the difference between a local and a global temporary table? : Sql dba

0 Answers  

Explain the insert into statements in sql?

0 Answers  

What is count * in sql?

0 Answers  

What is sql injection owasp?

0 Answers  

What is trigger in pl sql?

0 Answers  

Explain the structure of pl/sql in brief.

0 Answers  

What are the parameter modes supported by pl/sql?

0 Answers  

What is the use of <> sql?

0 Answers  

What is a data definition language?

0 Answers  

How to maintain the history of code changes of pl/sql?

3 Answers  

how to use regular expression in pattern match conditions? : Sql dba

0 Answers  

how to use in conditions? : Sql dba

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories