Interested to Buy Any Domain ? << Click Here >> for more details...
what are the components of database architecture?
- 6 Answers
- 12870 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 do you mean by atomicity and aggregation?
What is database architecture? : sql server architect
What is raid and what are different types of raid configurations? : sql server architect
What are page splits? : sql server architect
Explain what are the restrictions that views have to follow? : sql server architect
What is single tier architecture?
State about the security aspects of stored procedures?
Are the resulting relations of PRODUCT and JOIN operation the same?
What is 3NF?
can we use transformer in datastage without any input link?
What is an Entity set?
Explain about recursive stored procedures?
-
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)
