If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)
No Answer is Posted For this Question
Be the First to Post Answer
You have installed oracle and you are now setting up the actual instance. You have been waiting an hour for the initialization script to finish, what should you check first to determine if there is a problem?
When should the default values for oracle initialization parameters be used as is?
What are the different types of backup available in the oracle?
Give one method for transferring a table from one schema to another?
Explain the various modes of normalization?
Tell me about standby database? What are some of the configurations of it? What should we watch out for?
Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?
How many control files should you have? Where should they be located?
If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?
How do I become a data manager?
What is the meaning of database backup?
What does dba stand for in technology?