> > >

Microsoft SQL Server MCQs

Which of the following is a valid code to change the index created on a column of a table to page compression?

ALTER INDEX Index_Product ON Table1 WITH ( DATA_COMPRESSION = PAGE ) GO

ALTER INDEX Index_Product ON Table1 SET ( DATA_COMPRESSION = PAGE ) GO

ALTER INDEX Index_Product ON Table1 REBUILD WITH ( DATA_COMPRESSION = PAGE ) GO

ALTER INDEX Index_Product ON Table1 REBUILD SET ( DATA_COMPRESSION = PAGE ) GO

Answer

Correct Answer: ALTER INDEX Index_Product ON Table1 REBUILD WITH ( DATA_COMPRESSION = PAGE ) GO

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Microsoft SQL Server Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it