GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Oracle  >  Database Administration

 Print  |  
Question:  What are the components of physical database structure of Oracle database



January 01, 2008 09:47:36 #9
 kssatya.69   Member Since: December 2007    Total Comments: 2 

RE: What are the components of physical database structure of Oracle database
 

The database when made in oracle 10g consists a minimum of
----Two datafiles on the two manadatory tablespaces system and sysaux
----Control file multiplexed or not (Oracle recommends three)
----two online redolog files with atleast one member each.

Apart from the physical componenets mentioned above orcale database also consists of
---password file,
---parameter file and or spfile,
---and other datafiles depending on the application.

     

 

Back To Question