What is main function of database administrator?
No Answer is Posted For this Question
Be the First to Post Answer
Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?
What command is used to type files to the screen?
I am getting error "no communication channel" after changing the domain name? What is the solution?
Who is a database user?
If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)
What are four common errors found in an alert .log?
What is pct free/pct used/pct increase parameter in segment?
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?
Discuss row chaining, how does it happen?
What are the five functions of a database?
How does one create a new database?
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?