Answer Posted / kishore
DBCC dbreindex('tabname','indexname','fillfactor')
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
what functionality does oracle provide to secure sensitive information?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What is the default fill factor value? : sql server DBA
What the different topologies in which replication can be configured? : sql server DBA
what are the types of connection load-balancing?
What are the steps you will take to improve performance of a poor performing query?
what is a user-defined lock?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
What are the commands used in dcl? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
What is the difference between dropping a database and taking a database offline? : sql server DBA
suppose you want to audit specific activities on sensitive data. How can you achieve that?