what are the components of database architecture?

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 a two tier wage system?

0 Answers  


Explain about recursive stored procedures?

0 Answers  


What is external database?

0 Answers  


can we use transformer in datastage without any input link?

0 Answers   Cognizant, CTS,


What is parallel database architecture?

0 Answers  






What is Multivalued dependency?

0 Answers  


What is E-R model?

0 Answers  


What is Data Storage - Definition Language?

0 Answers  


What is a Relation Schema and a Relation?

0 Answers  


Why fastload support to empty table?

0 Answers   CTS,


What is durability in DBMS?

0 Answers  


What is database architecture? : sql server architect

0 Answers  


Categories