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
How many types of stored procedure?
What are the different phases of transaction?
What is VDL (View Definition Language)?
What is join dependency and inclusion dependency?
What is the difference between cube operator and roll up operator? : sql server architect
What are external procedures ? Why and when they are used?
What is the difference between layer and tier?
What is DML Compiler?
What is degree of Relationship type?
What is internal database?
What is difference between two tier and three tier?
How does Tuple-oriented relational calculus differ from domain-oriented relational calculus
What is Set-at-a-time or Set-oriented?
What are page splits? : sql server architect
What is Relationship set?