Does dba need to know programming?
No Answer is Posted For this Question
Be the First to Post Answer
If you are not sure what command does a particular unix function what is the best way to determine the command?
List five most important parameter in 9i affecting performance?
Explain the term 'oracle grid architecture'?
You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?
What is the difference between truncate and delete? Why is one faster? Can we rollback both? How would a full table scan behave after?
While taking hot backup (begin end backup) what will happens back end?
The system administrator tells you that the system has not been rebooted in 6 months, should he be proud of this?
What does >> do?
A tablespace has a table with 30 extents in it. Is this bad? Why or why not.
What should a dba know?
What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?
Discuss row chaining, how does it happen? How can you reduce it?