please explain database architecture..



please explain database architecture.. ..

Answer / rahul khanke

hi,
basic oracle architecture is devided in 3 stages
1. storage structure
1. physical storage
a. data file
b. control file etc..
2.logical storage
a. tablespace
b. extents etc..
2. memory structure
a. SGA
b. PGA
2. process structure
1. mandatory process
a. SMON
b. PMON etc
2. optional process

and much more

Is This Answer Correct ?    8 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What normalization means?

0 Answers  


When do we use triggers?

0 Answers  


What is sqlexception in java?

0 Answers  


What is a temporal data type?

0 Answers  


Is sqlite thread safe?

0 Answers  


what is view? : Sql dba

0 Answers  


What are variables in pl sql?

0 Answers  


What is user defined functions?

0 Answers  


How can we optimize a sql query?

0 Answers  


What is the maximum size of sqlite database?

0 Answers  


How do you explain an index number?

0 Answers  


Explain the update statement in sql

0 Answers  


Categories