GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle  >  Concepts and Architecture
Go To First  |  Previous Question  |  Next Question 
 Concepts and Architecture  |  Question 2 of 74    Print  

What are the components of Logical database structure of ORACLE database?

Tablespaces and the Database's Schema Objects.




  
Total Answers and Comments: 4 Last Update: September 08, 2008   
  
 Sponsored Links

 
 Best Rated Answer
Submitted by: puneet soni
 
there are two types of database 1) logical database 2)physical databaselogical database consist of tablespaces....and a tablespace consist of one or more segments....a segment consist of one or more extents.....an extent consist of contigious oracle data blocks.logical database contain objects of users such as tables,indexes etc.

Above answer was rated as good by the following members:
bhatnagar_neeraj
February 17, 2006 02:04:10   #1  
puneet soni        

RE: What are the components of Logical database...
there are two types of database 1) logical database 2)physical databaselogical database consist of tablespaces....and a tablespace consist of one or more segments....a segment consist of one or more extents.....an extent consist of contigious oracle data blocks.logical database contain objects of users such as tables indexes etc.
 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
September 20, 2007 00:44:44   #2  
Mohammed Abdul Afroze        

RE: What are the components of Logical database...
Components of a Logical Structure of a Database are as follows:

Tablespaces--->Segments---->Extents----->Data Blocks.

 
Is this answer useful? Yes | No
June 06, 2008 10:09:16   #3  
sbing Member Since: June 2008   Contribution: 1    

RE: What are the components of Logical database structure of ORACLE database?

Components of Logical Database

Attributes
Relationships
Entities

Components of Physical Database

Elements
Constraints
Tables


 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
September 08, 2008 08:47:37   #4  
vpramn Member Since: September 2008   Contribution: 1    

RE: What are the components of Logical database structure of ORACLE database?
Oracle Database has Physical and Logical Structure. In Logical Structure contains System tablespace and no of tablespace in database. these tablespace contains datafiles from physical database datafiles
 
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