GeekInterview.com
  I am new, Sign me up!
 

Oracle DBA Interview Questions


Oracle DBA Interview Questions

Questions: 231
Comments: 477
 Oracle DBA Tags
 Showing Questions 1-10 of 231 Questions
[1] 2 3 4 5 6 7 8 9 10 Next >>
 Sponsored Links

 
 Oracle DBA Interview Questions
Sorting Options :  

Explain what are Oracle Catalog and Oracle Archive log? 
Latest Answer: Oracle System Catalog :System Created Tables Which Contain Statistics and Useful Data Collected Automatically by the Database Engine to Help the Administrator or the regular users.There Are Several Kinds Of Catalogs :V$_Catalogdba_CatalogUser_Catalog RMAN ...
Read Answers (5) | Asked by : gyanudba

What is PCT Free and PCT Used?What is PCT increase parameter in segment?What is growth factor? 
Latest Answer: This is the parameter which specify in percent  that a block can only used for insert or come in the freelist(list of blocks in segment ready for insert operation) when used space in a block is less than PCTUSED.Suppose value of pctused is 40% and pctfree ...
Read Answers (3) | Asked by : gyanudba

What is dump destination? What are bdump, cdump and udump? Explain in detail. 
Latest Answer: The dump destination is: Oracle_home/admin/The UDUMP specifies user dump directory where all the user related information is stored in the form of trace file.The BDUMP specifies background dump directory where background processes information ...
Read Answers (4) | Asked by : gyanudba

What are four performance bottlenecks that can occur in a database server and How are they detected? 
Latest Answer: What smruti11 mentioned is absolutely right, That is why I rated his answer as good. I am just gonna brief about the troubleshooting steps though. Four major steps:- Analyzing Optimizer Statistics Analyzing an Execution Plan Using Hints to ...

What are four errors found in an alert (error) log that can ruin a DBA's appetite and how can you avoid them? 
Latest Answer: I personally feel that more error we come across, more stronger our roots become.  Errors are not gonna ruin the DBA's apettite. Both my pals above forgot the most notable 'ORA-00600 (Internal Error)'. They occur more than the most. :) And of course ...

Can you perform DML operations when the standby database is in read only in Standby Database? 
Latest Answer: In a nutshell, One can do SELECTS only on a Physical/Logical Standby database. The basic principle behind Oracle Standby database is to provide protection against media failures. So no DMLs are allowed on the standby database and the most important things ...

What will you do if in any condition you do not know how to troubleshoot the error at all and there are no seniors or your co-workers around? 
Latest Answer: We need to find where in the complilation the error is occuring.We have to divide the code. and check for correctness of the code part-by-part..this is called debugging. Keep checking the code untill you find the code which is wrong.hope this answer helps.Raghu. ...

What are the different scenarios for rebuilding indexes... 
Latest Answer: Actually you need to rebuild the indexes for 2 main scenarios.1)deleted entries represents 20% or more of the current entries2)the index depth is more than 4 levelsOracle index nodes are not deleted physically when the rows of tables deleted nor the entries ...
Read Answers (1) | Asked by : alex.v

Latest Answer: Local to Dictionary managed tablespcaes:exec dbms_space_admin.Tablespace_Migrate_FROM_Local('tablespace');Dictionary to locally managed tablespaces:exec dbms_space_admin.Tablespace_Migrate_to_Local('tablespace'); ...

As a Oracle DBA what are all the UNIX file you should be familar with?  
Latest Answer: To check the process useps -ef |grep pmonps -efTo check the alert log filetail -f alert.log To check the cpu usagetopvmstat 2 5 ...

View page [1] 2 3 4 5 6 7 8 9 10 Next >>

Ask A Question
Go Top
 Sponsored Links

 
Sponsored Links

 
Ask Question
You must login to Ask Question or Register your free account

Category:

 
Question Title:


Question in Detail:

Add this to my Subscribed Questions (?)
Send me email when new answer is posted (?)

 
Subscribe
Get Latest Updates Via RSS Reader or by Email
 Forum Discussion Subscribe to Forum Discussions Via E-Mail Latest Forum Discussions Subscribers
 Knowledge Base Subscribe to Knowledge Base Series Via E-Mail Knowledge Base Subscribers
 Learning Series Subscribe to GeekInterview Learning Series Via EMail Learning Series Subscribers
 Freelance Jobs Subscribe to GeekInterview Freelance Jobs Via EMail Latest Freelance Jobs Subscribers
 GeekInterview Blog Subscribe to GeekInterview Blog Via EMail GeekInterview Blog Subscribers
 Testing Interview Questions Subscribe to Testing Interview Questions Via EMail Testing Interview Questions Subscribers
 Oracle Interview Questions Subscribe to Oracle Interview Questions Via EMail Oracle Interview Questions Subscribers
 Java Interview Questions Subscribe to Java Interview Questions Via EMail Java Interview Questions Subscribers
 Latest Placement Papers Subscribe to Latest Placement Papers Placement Papers Subscribers
 Free Training Subscribe to Free Training Via EMail Free Training Subscribers
 Learn AJAX Subscribe to AJAXwith.com Via EMail AJAXwith Subscribers
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