What are the five main functions of a database administrator?
No Answer is Posted For this Question
Be the First to Post Answer
Who is a database user?
You look at the dba_rollback_segs view and see that there is a large number of shrinks and they are of relatively small size, is this a problem? How can it be fixed if it is a problem?
How can you tell if an index on particular table is used or not used in 9i?
Explain procedure to change characterset of a database.
How do you analyze table partition using oracle provided package?
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 a dba why is this position necessary?
How many control files should you have? Where should they be located?
What are the different types of database users?
How to drop an oracle database?
Explain force logging feature in 9i.
What skills do you need to be an administrator?