| |
GeekInterview.com > Interview Questions > Oracle > Database Administration
| Print | |
Question: What are the components of physical database structure of Oracle database
|
| March 03, 2005 00:01:01 |
#1 |
| nishit patel |
Member Since: Visitor Total Comments: N/A |
RE: What are the components of physical database structure of Oracle database
|
| totally there are 6 files(components) of physical database structure.3 mandatory & 3 optional.Three mandatory files are :1> datafile : store actual data 2> control file : strores stuctural & status information of database.3> redolog file : stores changed/committed dataThree optional files are :4> parameter file : strores all size related parameters note : this file is mandatory for a1st time u create a database, then it is optional. 5> archivelog file : its offline copy of redolog files6> password file : used to make normal user to behave as a super user.Best Of Luck,Questions & Doubts are most welcome.By Nishit Patel.mailid : nishitptl@yahoo.co.in |
| |
Back To Question | |
