Answer Posted / kishore
DBCC dbreindex('tabname','indexname','fillfactor')
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is the default fill factor value? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What are the recovery models for a database? : sql server DBA
suppose you want to audit specific activities on sensitive data. How can you achieve that?
What is dcl? : sql server DBA
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?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What purpose does the model database server? : sql server DBA
What are the commands used in dcl? : sql server DBA
You create a private database link and upon
connection, fails with: ORA-2085: connects to
how can you record information about current session?
What is dbcc? : sql server DBA
what do you understand by flashback feature of oracle?