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

How pl/sql source code can be protected?

3 Answers  

If i insert record in table A and these record should update in table B by using Trigger.How to achieve this.

4 Answers   Saama Tech, TCS,

What is a unique key and primary key and foreign key?

0 Answers  

What is the difference between RDBMS and DBMS?

20 Answers   Practical Viva Questions, Sapient, Stag Computers,

what are rollup and cube in t-sql? : Transact sql

0 Answers  

What does stand for in sql?

0 Answers  

What is use of trigger?

0 Answers  

Explain dml and ddl?

0 Answers  

What cursor type do you use to retrieve multiple recordsets?

17 Answers   Apollo, CTS, IonIdea, Microsoft, Oracle, TCS, Vmoksha, Wipro,

What are string functions in sql?

0 Answers  

What are sql objects?

0 Answers  

What is compiled query?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories