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



February 02, 2008 14:40:42 #10
 g.mrunalini   Member Since: February 2008    Total Comments: 8 

RE: What are the components of physical database structure of Oracle database
 
The physical components of the database consists of
                  Datafiles -- which contains the actual data of the database and minimum two datafiles are must in a database
                  Redo log files -- which contains the latest transaction in the database and minimum two redo log files are must in a database
                  Control files -- which contains the valuable information of the database which includes database name, SCN number, location of datafiles, location of redo log files
     

 

Back To Question