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 does myisamchk do? : Sql dba

0 Answers  

Is pl sql useful?

0 Answers  

What do you mean by dbms? What are its different types?

0 Answers  

How do you run a query?

0 Answers  

What is execution plan in sql?

0 Answers  

When we give SELECT * FROM EMP; How does oracle respond?

24 Answers   Accenture, HCL, Infosys,

In a distributed database system, can we execute two queries simultaneously?

0 Answers  

What is the difference between anonymous block and named blocks?

3 Answers  

what are set operators in sql? : Sql dba

0 Answers  

Is progress software supports to ( pl/sql )?

0 Answers  

How to process query result in pl/sql?

0 Answers  

What is dynamic SQl and how you will create and execute dynamic sql?

2 Answers   TCS,

For more SQL PLSQL Interview Questions Click Here
Categories