what are the components of database architecture?
Answer Posted / 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 |
Post New Answer View All Answers
Which part of the RDBMS takes care of the data dictionary? How
What is DML (Data Manipulation Language)?
What is an Entity set?
What are the three tiers in a 3 tier architecture?
What is Relationship set?
what is the difference between LENGTH AND SIZE?
How is the data structure of System R different from the relational structure?
What is Functional Dependency?
What is Relational Calculus?
Explain the benefits of running stored procedure on a database engine?
What is BCNF (Boyce-Codd Normal Form)?
Name the buffer in which all the commands that are typed in are stored
What is "transparent DBMS"?
What is the difference between layer and tier?
What is the difference between stored procedures and stored functions in oracle?