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

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

0 Answers  

What are different methods to trace the pl/sql code?

0 Answers  

what is check constraint? : Sql dba

1 Answers  

What is normalisation and its types?

0 Answers  

What are %type and %rowtype for?

0 Answers  

How can you select unique records from a table?

0 Answers  

display null value rows with out using null function?

8 Answers   Infosys,

How do you copy a table in sql?

0 Answers  

Talk about views

10 Answers   Polaris,

Which tcp/ip port does sql server run?

0 Answers  

explain advantages of innodb over myisam. : Sql dba

0 Answers  

What is diff between bulk collect and forall

3 Answers   Metric Stream,

For more SQL PLSQL Interview Questions Click Here
Categories