1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

please explain database architecture..

Question Posted / neelima.gg


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

Difference between table function and pipelined function?

0 Answers  

What are properties of the transaction?

0 Answers  

what is data integrity? : Sql dba

0 Answers  

What is procedure and function?

0 Answers  

What are stored procedures in mysql?

0 Answers  




What is difference between joins and union?

0 Answers  

How can you know that statistics should be updated?

0 Answers  

How can we link a sql database to an existing android app?

0 Answers  

What is record in pl sql?

0 Answers  

how to give permission to users that users can update/insert/delete on a row of table on timeing 10am to 6pm only?

4 Answers   TCS,

What is difference between select statement and cursor

3 Answers   JDA,

what is data manipulation language? : Sql dba

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories