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: 225
Comments: 390
 Oracle DBA Tags
 Showing Questions 61-70 of 225 Questions
<< Previous 3 4 5 6 [7] 8 9 10 11 12 Next >>
 Sponsored Links

 
 Oracle DBA Interview Questions
Sorting Options :  

What is OERR Utility 
View Question | Asked by : Pragati.rch

How many max datafiles can there be in an Oracle Database. 
View Question | Asked by : Pragati.rch

How do you control No. of Datafiles one can have in an Oracle Database. 
View Question | Asked by : Pragati.rch

How to write script for export backup in shell.  
View Question | Asked by : Pragati.rch

You have a database. You have a datafile and some blocks are corrupted in the datafile. What statement will you issue to know how many blocks are corrupted? 
Latest Answer: you can use the DBVERIFY utility to check the corruption in datafiles so that you can now number of blocks corrupted.Here is the procedure :On o/s prompt login as oracle user : $ dbv file= 'datafile name'now in the output check for the ...

What is standby databases? Difference between Physical and logical standby databases 
Latest Answer: A standby database is a transactionally consistent copy of the primary database. Using a backup copy of the primary database, you can create up to nine standby databases.A standby database can be either a physical standby database or a logical standby ...

What is a flash back query? This feature is also available in 9i. whats the difference between 9i and 10g (related to flash back query). 
Latest Answer: Oracle 10g offers significant enhancements that help insure the high availability of any Oracle database, as well as improvements in the database disaster recovery arena. This paper explores one of the most intriguing new features of Oracle 10g: Flashback ...

Tell me any instance when your database encountered any problem. How you dealt with that problem.  
View Question | Asked by : Pragati.rch

Show one instance when you encountered an error in alert log and you overcome that error. What actions you took to overcome that error. 
Latest Answer: Hi,Oracle write error in alert log file. Depending upon the error corrective action needs to be taken.1) DeadLock Error : Take the trace file in user dump destination and analysis it for the error.2) ORA-01555 Snapshot error. Check the query try to fine ...

Describe four properties of database isolation. In which situation lock contention will happen. What is transaction lock? 
View Question | Asked by : Pragati.rch

View page << Previous 3 4 5 6 [7] 8 9 10 11 12 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