ALLInterview.com :: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Google
   
 
Categories >> Software >> Databases >> Oracle >> Architecture
 
 


 

 
 Oracle General interview questions  Oracle General Interview Questions (718)
 OCI interview questions  OCI Interview Questions (10)
 Architecture interview questions  Architecture Interview Questions (75)
 Oracle Security interview questions  Oracle Security Interview Questions (37)
 Database Management interview questions  Database Management Interview Questions (264)
 Forms Reports interview questions  Forms Reports Interview Questions (466)
 Oracle AllOther interview questions  Oracle AllOther Interview Questions (181)
Question

how oracle will recognise its space is 100gb
 if 100gb is allocated for it...
 Question Submitted By :: Architecture
I also faced this Question!!     Answer Posted By  
 
Answer
# 1
select bytes/1048576 from dba_free_space where
tablespace_name='';
 
Is This Answer Correct ?    9 Yes 5 No
Manjeet Kumar
 

 
 
 
Other Architecture Interview Questions
 
  Question Asked @ Answers
 
Name the ORACLE Background Process?   3
how oracle will recognise its space is 100gb if 100gb is allocated for it...   1
What is use of Rollback Segments In Database ?   4
What is User Process?   1
How many Dispatcher Processes are created?   1
When will be a segment released?   1
What is the role of PCTFREE parameter is Storage clause ?   2
What is the significance of having storage clause ?   1
THE MAIN CONCEPT OF PROGRAMMIN TYPE?   1
How does Space allocation table place within a block ?   1
How the space utilisation takes place within rollback segments?   2
What Does DBWR do?   2
 
For more Architecture Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
   
Copyright 2013  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  KalAajKal.com