What is the dba role in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
What are the goals of dba?
Describe hit ratio as it pertains to the database buffers. What is the difference between instantaneous and cumulative hit ratio and which should be used for tuning?
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.
How can you find your id on a system?
If you see the value for reloads is high in the estat library cache report is this a matter for concern?
What is your favorite tool for day-to-day oracle operation?
How do you set up your tablespace on installation level: low?
What causes the "snapshot too old" error? How can this be prevented or mitigated?
What happens if the constraint name is left out of a constraint clause?
What is a dba programmer?
What do you understand by the term 'normalization'? Explain the various modes of normalization?
What does the no logging option do? Why would we be careful of using it?