what are the components of database architecture?
Answer Posted / 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 |
Post New Answer View All Answers
What is 4NF?
What is n tier architecture with example?
What is one tier architecture?
What is BCNF (Boyce-Codd Normal Form)?
Explain what are the database objects? : sql server architect
Explain the truncate command? : sql server architect
What is meant by query optimization?
What do you mean by atomicity and aggregation?
Explain about the difficulties faced by the database developer in implementing pre compiled statements?
What is RDBMS KERNEL?
How does Tuple-oriented relational calculus differ from domain-oriented relational calculus
What is Domain-Key Normal Form?
What do data architects do?
Do you know what the restrictions applicable while creating views are? : sql server architect
Explain about the return statement?