What do you understand by recovery catalog?
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?
You see the following on a status report: redo log space requests 23 redo log space wait time 0 is this something to worry about? What if redo log space wait time is high? How can you fix this?
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?
You see multiple fragments in the system tablespace, what should you check first?
What skills do you need to be an administrator?
What are the goals of dba?
What are the different types of database users?
What is the difference between sga and pga?
What do you understand by the term 'system change number (scn)'?
Which database is best to learn?
How long does it take to learn database administration?
What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?