GeekInterview.com
Series: Subject: Topic:
Question: 250 of 250

What are the components of physical database structure of Oracle database

Asked by: Interview Candidate | Asked on: Sep 2nd, 2005
Showing Answers 1 - 16 of 16 Answers
nishit patel

Answered On : Mar 12th, 2005

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

Yes  2 Users have rated as useful.
  
Login to rate this answer.
Jacob

Answered On : Jul 9th, 2005

ORACLE database is comprised of three types of files. One or more Data files, two are more Redo Log files, and one or more Control files.

Yes  1 User has rated as useful.
  
Login to rate this answer.
Taral Desai

Answered On : Sep 2nd, 2005

1. control files 
2. init file 
3 log files 
4 redo/archive log files 
5 data files 

Yes  1 User has rated as useful.
  
Login to rate this answer.
shalini

Answered On : Sep 12th, 2005

physical components of oracle database are control files,redo log files and datafiles.

Control file: control file is read in the mount state of database. control file is a small binary file which records the physical structure of database which includes

  • database name
  • names and locations of datafiles and online redo log files.
  • timestamp of database creation
  • check point information
  • current log sequence number.

Redo log files: This files saves all the changes that are made to the database as they occur. This plays a great role in the database recovery.

Datafiles:datafiles are the physicalfiles which stores data of all logical structure.

Yes  4 Users have rated as useful.
  
Login to rate this answer.
cmanne

Answered On : Jan 4th, 2006

View all answers by cmanne

1. Data files2. Redolog files3. Control File4. init.ora file

Yes  1 User has rated as useful.
  
Login to rate this answer.
monanathan87

Answered On : Jan 4th, 2007

View all answers by monanathan87

The components are

Data files
Redo log files
Control files
Data files are used to store all the database objects which are administered by the oracle system.
Redo log files contain records of all database changes which are carried out in the course of transactions
Control files record information about physical structure of database

  
Login to rate this answer.
RAVI

Answered On : Jan 8th, 2007

Components of Physical database are:-

1. Datafile -- One or more

2. Redo log file -- Two or more

3. Control File --- Two or more

Thanks

Yes  1 User has rated as useful.
  
Login to rate this answer.
txrob00

Answered On : Jan 25th, 2008

View all answers by txrob00

What are the components of physical database structure of Oracle database

  
Login to rate this answer.
kssatya.69

Answered On : Jan 28th, 2008

View all answers by kssatya.69

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.

Yes  2 Users have rated as useful.
  
Login to rate this answer.
g.mrunalini

Answered On : Feb 12th, 2008

View all answers by g.mrunalini

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

Yes  1 User has rated as useful.
  
Login to rate this answer.
anjali08

Answered On : Feb 13th, 2008

View all answers by anjali08

datafile,control file and redo logs

  
Login to rate this answer.
rajat_dua

Answered On : Mar 3rd, 2009

View all answers by rajat_dua

Components of Physical database are:-

1. Datafile -One or more
2. Redo log file - Two or more
3. Control File -Two or more

  
Login to rate this answer.
premk

Answered On : Dec 22nd, 2009

View all answers by premk

The physical structure of ORACLE database consists of three major components.
They are:
1. control files
2. redo log files
3. data files

  
Login to rate this answer.
rajesh.dba9i

Answered On : Feb 16th, 2010

View all answers by rajesh.dba9i

Datafiles, Controlfile and online redo log file.

  
Login to rate this answer.
dj_dj_dj

Answered On : Feb 18th, 2010

View all answers by dj_dj_dj

Dear, 


           Oracle Physical Database Structure consist of Datafiles, Controlfile  & Online Redo Log files.

           Logical Structure consist of Tablespaces and its components inclusive of tables.


Regards
Dharmedra Jaiswal.

  
Login to rate this answer.
vanithaananth

Answered On : Jun 24th, 2011

View all answers by vanithaananth

physical structures of oracle database consists of datafiles,controlfiles redologfiles and archivelogfiles...

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Ads

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.