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 >> DB Architecture
  2. Suggest New Category

what are the components of database architecture?

Question Posted / sharmisha.9

Answers were Sorted based on User's Feedback



what are the components of database architecture?..

Answer / hannan oca

according to oracle database

1.Oracle instance
SGA(system global area)
shared pool
buffer memory for transactions
Redo log buffer
large pool
java pool
PGA(program global area)

2 Memory slots(for datatables)

Is This Answer Correct ?    17 Yes 2 No

what are the components of database architecture?..

Answer / trupti b.raul.

Oracle Primary Component-
1.oracle Database
2.oracle server
3.Oracle instance

Is This Answer Correct ?    3 Yes 1 No

what are the components of database architecture?..

Answer / muthukumar

the major two components of oracle database architecture is
oracle instsnce and database.
-- instance allocate in RAM memory
-- database allocate in harddisk memory
-- instance classifieds into memory components and background process
-- memory component classifieds into SGA,PGA,UGA
-- BACKGROUND PROCESS classifieds into system monitor(SMON),process monitor(PMON), DBwriter, LOGwriter, checkpoint, etc....
-- the logical unit of database is tablespace
-- tablespace physically consist of datafile,control file, log file

Is This Answer Correct ?    1 Yes 1 No

what are the components of database architecture?..

Answer / john

instance-bg process(ckpt,dbwr,lgwr,dnnn,pmon,smon),memory(sga,pga)
storage-tablespace(segment,extent,block),physical files(parameter file,data file, etc)

Is This Answer Correct ?    0 Yes 0 No

what are the components of database architecture?..

Answer / nagireddy karri

The main components of oracle database architecture are
Oracle instance(System Global Area and BackGround Processes)
oracle database(datafiles,control files,online
redologgroups)

Is This Answer Correct ?    0 Yes 1 No

what are the components of database architecture?..

Answer / sharmisha.9

storage processor
query processor

Is This Answer Correct ?    7 Yes 9 No

Post New Answer

More DB Architecture Interview Questions

What is msdb database? : sql server architect

0 Answers  

What does n tier mean?

0 Answers  

What is SDL (Storage Definition Language)?

0 Answers  

What is Relational Algebra?

0 Answers  

What is join dependency and inclusion dependency?

0 Answers  

What is 2NF?

0 Answers  

What is an Extension of entity type?

0 Answers  

what is the difference between LENGTH AND SIZE?

0 Answers   Enercon,

What is Data Storage - Definition Language?

0 Answers  

What is master database? : sql server architect

0 Answers  

What is meant by query optimization?

0 Answers  

What is "transparent DBMS"?

0 Answers  

For more DB Architecture Interview Questions Click Here
Categories