Interested to Buy Any Domain ? << Click Here >> for more details...
what are the components of database architecture?
- 6 Answers
- 12917 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / trupti b.raul.
Oracle Primary Component-
1.oracle Database
2.oracle server
3.Oracle instance
| Is This Answer Correct ? | 3 Yes | 1 No |
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 |
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 |
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 is raid and what are different types of raid configurations? : sql server architect
What is one tier architecture?
What is degree of Relationship type?
What is a Phantom Deadlock?
Explain about the process which takes place to execute a stored routine?
What is the difference between a user defined function and a stored procedure?
What is meant by query optimization?
What are the levels of architecture?
Explain the microsoft sql server delete command? : sql server architect
What is the difference between 3 tier and 3 layer architecture?
Explain about the return statement?
What is an Extension of entity type?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
