CompTIA
DS0-001 · Question #100
Which of the following commands when executed will rebuild statistics against user-defined tables in a database?
Sign in or unlock DS0-001 to reveal the answer and full explanation for question #100. The question stem and answer options stay visible for context.
Database Management and Maintenance
Question
Which of the following commands when executed will rebuild statistics against user-defined tables in a database?
Options
- Asp_autostats
- Bsp_updatestats
- CDBCC UPDATEUSAGE
- DDBCC SHOW_STATISTICS
Unlock DS0-001 to see the answer
You've previewed enough free DS0-001 questions. Unlock DS0-001 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#SQL Server statistics#Database maintenance#sp_updatestats