GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

Oracle DBA Interview Questions


Oracle DBA Interview Questions

Questions: 224
Comments: 385
 Oracle DBA Tags
 Showing Questions 11-20 of 224 Questions
<< Previous 1 [2] 3 4 5 6 7 8 9 10 Next >>
 Sponsored Links

 
 Oracle DBA Interview Questions
Sorting Options :  

If the large table contains thousands of records and the application is accessing 35% of the table which method to use: index searching or full table scan?  
Latest Answer: To improve the performance we have to go for index searching. ...

In which situation whether peak time or off peak time you will execute the ANALYZE TABLE command. Why?  
Latest Answer:  Gathering statistics can be very resource intensive for the server so avoid peak workload times to gather stale stats or Analyze Table . ...

How to check to memory gap once the SGA is started in Restricted mode?  

If the SQL * Plus hangs for a long time, what is the reason? 

How do you increase the performance of %LIKE operator? 

Explain Dual table. Is any data internally stored in dual table. Lot of users are accessing select sysdate from dual and they getting some millisecond differences. If we execute SELECT SYSDATE FROM EMP; 
Latest Answer: Dual is a system owned table created during database creation. Dual table consist of a single column and a single row with value xWe will not get any error if we execute select sysdate from scott.emp  Instead sysdate will be treated as a psudo column ...

In exception handling we have some NOT_FOUND and OTHERS. In inner layer we have some NOT_FOUND and OTHERS. While executing which one whether outer layer or inner layer will check first?  

What is mutated trigger? In single user mode we got mutated error, as a DBA how you will resolve it?  

Schema A has some objects and created one procedure and granted to Schema B. Schema B has the same objects like Schema A. Schema B executed the procedure like inserting some records. In this case where 
Latest Answer: Procedure will be executed with the authority of A and therfore data will go to the tables owned by A. If one wants the data to go to B, use the clause authid current_user while defining the procedure. ...

If the entire disk is corrupted how will you recover the database and what are the steps to recover the database?  
Latest Answer: Succesful backup is possible iff there is "Archive Mode" is on.that is database is in Archive Mode.and if it's offthen there are only 99.9% chancesthroughGroup1 or Group2 of Online Redo log files. ...

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

Ask A Question
Go Top
 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
Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape