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 program debugging?

0 Answers  

Show the two pl/sql cursor exceptions.

0 Answers  

Why query optimization is needed?

0 Answers  

How do you identify a primary key?

0 Answers  

Does inner join remove duplicates?

0 Answers  

How to add Foreign key in a table after the creation of the table?

5 Answers   Satyam,

What is attribute indicator in pl sql?

0 Answers  

What is the basic structure of an sql?

0 Answers  

Write the alter statement to enable all the triggers on the t.students table.

0 Answers  

How do you copy a table in sql?

0 Answers  

HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE.

16 Answers  

What is a .db file?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories