Interested to Buy Any Domain ? << Click Here >> for more details...
What is a dba programmer?
- 0 Answers
- 577 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
A dba had to remove some archivelogs to free up space in filesystem. Nowwhen the rman job starts to backup archivelogs, it complains about missing archivelogs thatwere deleted by dba. To resolve the issue and continue backing up remainder of archivelogs,which rman command can be used so it wo not complain about missing archivelogs.
What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?
What are the five main functions of a database administrator?
If you see the value for reloads is high in the estat library cache report is this a matter for concern?
Tell me about standby database? What are some of the configurations of it?
You are getting busy buffer waits. Is this bad? How can you find what is causing it?
What is dba and functionalities of dba?
What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?
What is the advantage of using rman?
If you see a pin hit ratio of less than 0.8 in the estat library cache report is this a problem? If so, how do you fix it?
Explain the process you follow to start looking into performance issue at database level(if the application is running very slow, at what points do you need to go about the database inorder to improve the performance?)
How can you find out how many users are currently logged into the database?
Oracle General 
