Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / kishore
DBCC dbreindex('tabname','indexname','fillfactor')
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
how can you enable flashback feature?
What are the operating modes in which database mirroring runs? : sql server DBA
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What the different types of replication and why are they used? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
what are the types of connection load-balancing?
What are the commands used in dcl? : sql server DBA
how can you implement fine-grained auditing?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
what is the use of ocr?
how can a session indicate its interest in receiving alerts?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
