GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle  >  Basics
Go To First  |  Previous Question  |  Next Question 
 Basics  |  Question 3 of 49    Print  
What is stucture of Database

  
Total Answers and Comments: 4 Last Update: May 15, 2008   
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
October 03, 2005 14:38:04   #1  
Sri        

RE: What is stucture of Database

Oracle database usually contains one database and a single instance. But Oracle 9i 10g RAC (Real Application Clusters) can have multiple instances to interact with a single database for high availability.

Instance is non-persistent memory based background processes and structures.

Database is persistent disk based data and control files


 
Is this answer useful? Yes | No
November 09, 2005 11:45:58   #2  
Chiranjeevi Manne        

RE: What is stucture of Database

Physical Structure of Database:

One or more datafiles control file(s) Redolog file(s) and init.ora file

Logical Structure of Database:

Tablespaces segments extents blocks


 
Is this answer useful? Yes | No
September 28, 2007 05:26:09   #3  
Mohammed Abdul Afroze        

RE: What is stucture of Database
The Physical Structure of a Database are as follows:

1.Controlfiles
2.Redo Log Files
3.Datafiles.

 
Is this answer useful? Yes | No
May 15, 2008 00:20:55   #4  
AshaMahesh Member Since: May 2008   Contribution: 1    

RE: What is stucture of Database

ther is Physical structure & Logical structure

Physical structure Consits of 3 files
one or more data files
two or more redo lof giles
one or more control files

Logical Structure includes

Tablespaces - is database divides into logical storage units
database scheme objects - logical structures that refer to database data


 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape