ALLInterview.com :: Home Page KalAajKal.com
 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                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Software  >>  Databases  >>  Oracle  >>  Architecture
 
 


 

 
 Oracle General interview questions  Oracle General Interview Questions
 OCI interview questions  OCI Interview Questions
 Architecture interview questions  Architecture Interview Questions
 Oracle Security interview questions  Oracle Security Interview Questions
 Database Management interview questions  Database Management Interview Questions
 Forms Reports interview questions  Forms Reports Interview Questions
 Oracle AllOther interview questions  Oracle AllOther Interview Questions
Question
how oracle will recognise its space is 100gb
 if 100gb is allocated for it...
 Question Submitted By :: B.neelu
I also faced this Question!!     Rank Answer Posted By  
 
  Re: how oracle will recognise its space is 100gb if 100gb is allocated for it...
Answer
# 1
select bytes/1048576 from dba_free_space where 
tablespace_name='';
 
Is This Answer Correct ?    1 Yes 1 No
Manjeet Kumar
 

 
 
 
Other Architecture Interview Questions
 
  Question Asked @ Answers
 
What Does DBWR do?  2
What is the function of Lock (LCKn) Process?  1
How will you force database to use particular rollback segment?  1
How the log writer writes the data into database Satyam1
How free extents are managed in Ver 6.0 and Ver 7.0 ? IBM1
List the Optional Flexible Architecture (OFA) of Oracle database ?  1
What is Server Process?  2
What is a Parallel Server option in ORACLE?  1
What is the role of PCTFREE parameter is Storage clause ?  2
How does Space allocation table place within a block ?  1
How will you monitor rollback segment status ?  1
How can you find the size of a database? HCL1
What is meant by Redo Log file mirrorring ? How it can be achieved?  1
What is dictionary cache ?  2
How can we plan storage for very large tables ?  1
What is meant by recursive hints ?  1
What are disadvanteges of having raw devices ?  1
What is function of RECO?  1
How to find the current session sid  2
What is a Multi-threaded Server Configuration?  1
 
For more Architecture Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com