Interested to Buy Any Domain ? << Click Here >> for more details...
what are the components of database architecture?
- 6 Answers
- 13139 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
What is an Entity set?
What is Relationship set?
what is the difference between LENGTH AND SIZE?
How one call ddl statement using stored procedures in oracle?
Explain what are the database objects? : sql server architect
Which is super key?
Are the resulting relations of PRODUCT and JOIN operation the same?
How do you communicate with an RDBMS?
What is a Relation Schema and a Relation?
What is Data Model?
What is difference between 2 tier and 3 tier architecture?
What is Lossless join property?
What is DDL (Data Definition Language)?
What is the difference between 3 tier and 3 layer architecture?
What is Functional Dependency?
