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 Difference between Having and Where clause?

5 Answers   IBM,

what is csv? : Sql dba

0 Answers  

how to get a list of indexes of an existing table? : Sql dba

0 Answers  

How many parts of a pl sql block are optional?

0 Answers  

When are we going to use truncate and delete?

0 Answers  

how to get a list of columns in an existing table? : Sql dba

0 Answers  

What are the different tcl commands in sql?

0 Answers  

what are the advantages and disadvantages of views in a database? : Sql dba

0 Answers  

what is an index? : Sql dba

0 Answers  

What is constant in pl sql?

0 Answers  

How do I delete a trigger?

0 Answers  

What is the difference between drop and truncate commands?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories