What types of database maintenance should be executed ?
A. Update SQL Server’s usage
B. Validate the database objects and system catalogs are free of corruption
C. Determine the fragmentation for tables and indexes
D. All of the mentioned
Answer:A
What types of database maintenance should be executed ?
A. Update SQL Server’s usage B. Validate the database objects and system catalogs are free of corruption C. Determine the fragmentation for tables and indexes D. All of the mentioned
Explanation:The SQL Server Maintenance Solution comprises scripts for running backups, integrity checks, and index and statistics maintenance on all editions of Microsoft SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, and SQL Server 2014.