> > >

Air Traffic Control 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:

Explanation:

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

Air Traffic Control Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it