ALLInterview.com :: Home Page Forum9.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   interview questions urls   External Links  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
Question 
How will you monitor the space allocation ?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How will you monitor the space allocation ?
Answer
# 1		 
this can be monitored in DB_data_files
 
Is This Answer Correct ?    0 Yes 0 No
Guest
 
  Re: How will you monitor the space allocation ?
Answer
# 2		 
SQL>desc dba_data_files;
SQL>desc v$tablespace;
SQL>select bytes from dba_data_files where tablespace_name 
like 'TABLSPACE_NAME';
 
Is This Answer Correct ?    0 Yes 0 No
Mohanish Sahoo
 
 
 
 
 
 
Other Architecture Interview Questions
 
  Question Asked @ Answers
 
Why query fails sometimes ?  1
Which parameter in Storage clause will reduce no. of rows per block?  1
What is a Multi-threaded Server Configuration?  1
What is meant by Redo Log file mirrorring ? How it can be achieved?  1
When Does DBWR write to the database?  4
What is a Parallel Server option in ORACLE?  1
What is SGA?  1
What is a Control file ?  2
What is the function of checkpoint(CKPT)?  1
How to implement the multiple control files for an existing database ?  1
How will you swap objects into a different table space for an existing database?  1
What is hit ratio ?  1
What are disadvanteges of having raw devices ?  1
How many Dispatcher Processes are created?  1
What is the function of Dispatcher (Dnnn)?  2
When will be a segment released?  1
What is dictionary cache ?  2
What is PGA?  3
Name the ORACLE Background Process?  2
What is the maximum number of Lock Processes used?  1
 
For more Architecture Interview Questions Click Here 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

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