How can you tell if an index on particular table is used or not used in 9i?
No Answer is Posted For this Question
Be the First to Post Answer
What is pct free/pct used/pct increase parameter in segment? What is growth factor?
Which files are vital that should be backed up?
What are the types of schemas?
What is oracle archived redo log?
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 do you understand by the term 'normalization'? Explain the various modes of normalization?
What is the difference between truncate and delete? How would a full table scan behave after?
What is dba software?
When should you increase copy latches? What parameters control copy latches?
What happens when the default and temp tablespace clauses are left out from create user statements?
How many control files should you have?
What is the purpose of the import option ignore? What is its default setting?