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 41-50 of 231 Questions
<< Previous 1 2 3 4 [5] 6 7 8 9 10 Next >>
 Sponsored Links

 
 Oracle DBA Interview Questions
Sorting Options :  

What tuning indicators can one use? 

Outline the steps required for physical standby database creation?  
Latest Answer: Hi all,IT IS POSSIBLE WITH THE HELP OF DATA GUARD.To  create a physical standby database ,the standby databse should be in MRM(Managed recovery mode)Let  we proceed with an example, let  db10 is a production database server and db15 is ...

If one user is already updating the table and it has a lock, the other user cannot access the table to update. then why and how the deadlock situation arises ?please explain with example. 

If Materialized view contains the actual data and has to be re-created every time the original table data is changed and we intent to refresh the data in the view.then what is the actual use of materialized 

What are the common problems while taking backups? What are the necessary steps to take backup on to tapes and disks in real time? 
View Question | Asked by : suresh299

Discuss the advantages and disadvantages of hierarchical database management system in comparison with RDBMS. Discuss types of applications suitable for hierarchical DBMS and RDBMS. 

I have applied the following commands:Shutdown abortstartupNow what will happen, will the database will give an error / it will work. 
Latest Answer: Yes,  Given no other factors, the database will start up without issue.  You killed all sessions, killed all transactions, and didn't write from the buffers.   Note that instance recovery will take place during startup. ...

exp userid=system/manager file=expfile.dmp log=expfile.log full=Y compress=Y buffer=1000000If i do't mention compress & buffer parameter , then this query will run/not. 
Latest Answer: Yes, exactly it will run perfectly because compress and buffer both are optional. ...

What is Ora1555 error. Snapshot too Old error. Explain in detail. 
Latest Answer: Oracle Rollback Segments (Undo more recently) hold a copy of data before it was modified, and they work in a round-robin fashion.  Writing and then eventually overwriting the entries as soon as the changes are committed. They are needed to provide ...

My database size is 100GB. I am using compress parameter. Will my database size reduce, remain same, Increase. What will Happen. 
Latest Answer: When "Y",export will mark the table to be loaded as one extent for the import utility. This option will use only if you want to do import. export size will not change if we use compress=y. ...

View page << Previous 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