Interested to Buy Any Domain ? << Click Here >> for more details...
what are the components of database architecture?
- 6 Answers
- 13318 Views
- Wipro, I also Faced
- E-Mail Answers
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
Name the sub-systems of a RDBMS?
What is an Entity set?
Explain about the implementation of business logic in stored procedures?
What is 2 tier 3 tier architecture?
What is single tier architecture?
What is 5NF?
What is the difference between "is" and "as" while creating procedure?
What is a query?
What is msdb database? : sql server architect
in oracle BPM composer in part BA model on design model in enterprise model i cannot connection with value chain model work not links in part properties do you can me help me?
What do you mean by Correlated subquery?
What is SDL (Storage Definition Language)?
What is Relationship type?
Can we use commit inside the trigger? If not then how can we save the transaction made by the trigger?
What are the primitive operations common to all record management systems?
