what are the components of database architecture?
- 6 Answers
- 11154 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 System R? What are its two major subsystems?
What are data segments?
What is BCNF (Boyce-Codd Normal Form)?
What is DML (Data Manipulation Language)?
Explain what are the database objects? : sql server architect
Do you know what the restrictions applicable while creating views are? : sql server architect
Are the resulting relations of PRODUCT and JOIN operation the same?
Which is super key?
What do you know about system database? : sql server architect
What is database architecture? : sql server architect
Explain about the return statement?
What is Relationship set?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
