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 71-80 of 231 Questions
<< Previous 4 5 6 7 [8] 9 10 11 12 13 Next >>
 Sponsored Links

 
 Oracle DBA Interview Questions
Sorting Options :  

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

The ratio of disk (sort) is high. Is that good or bad? Why? How will you reduce disk sort? 
Latest Answer: hi,Disk(sort)ratio is high is not good.Please set sort_area_retained_size and sort_area_size so that session can sort in max in memory. ...

What is simple replication and advance replication? What is the difference between simple replication and advance replication? How can we do simple replication? 
View Question | Asked by : Pragati.rch

DBMS_meta_data. This parameter is very usefull. What you infer from this parameter. What info you will find in that. explain in detail. 
Latest Answer: To find the structure of a external table we used this package.syntax is below:SELECT DBMS_METADATA.GET_DDL ('TABLE','')||';' FROM DUAL ...

What is Cache Fusion Technology? 
Latest Answer: Cache Fusion is a new technology that uses a high speed interprocess communication (IPC) interconnect to provide cache to cache transfers of data blocks between instances in a cluster. This eliminates disk I/O (which is inherently slow, since it is a ...

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