Symantec
ST0-118 · Question #195
An administrator has a Symantec Enterprise Vault 10 .0 for Exchange environment using SQL 2005 The administrator needs to run SQL maintenance to ensure the proper health of the EV environment. The…
The correct answer is D. DBCC SHOWCONTIG. See the full explanation below for the reasoning.
Question
An administrator has a Symantec Enterprise Vault 10 .0 for Exchange environment using SQL 2005 The administrator needs to run SQL maintenance to ensure the proper health of the EV environment. The administrator starts by checking the fragmentation of the databases. Which SQL command will show the administrator this information?
Options
- ADBCC CHECKTABLE
- BDBCC INDEXDEFRAG
- CDBCC SHOW_STATISTICS
- DDBCC SHOWCONTIG
How the community answered
(22 responses)- A5% (1)
- B5% (1)
- C9% (2)
- D82% (18)
Community Discussion
No community discussion yet for this question.