A tablespace has a table with 30 extents in it. Is this bad? Why or why not.
No Answer is Posted For this Question
Be the First to Post Answer
How do you put database is archivelog mode, explain procedure?
If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)
You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.
Explain the wait events in statspack report 'enqueue'?
What does a dba stand for?
What are types of data model?
What is a dba certification?
Explain the wait events in statspack report 'db sequential real'?
What do you mean by oracle database?
What are the different types of backup available in the oracle?
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?
What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?