Interested to Buy Any Domain ? << Click Here >> for more details...
what are the components of database architecture?
- 6 Answers
- 12925 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 |
Can somebody helps me to arrange these into ascending order depending on their sizes: 1)OLTP 2)ODS 3)DWH 4)DATA MART
What is Relational Calculus?
What is durability in DBMS?
What is 5NF?
What do you mean by atomicity and aggregation?
What are the primitive operations common to all record management systems?
What is the difference between stored procedures and stored functions in oracle?
What are the three tiers in a 3 tier architecture?
What is Domain-Key Normal Form?
How is the data structure of System R different from the relational structure?
What is a query?
What are the 3 levels of data abstraction?
-
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)
