> > >

Microsoft SQL Server MCQs

Which of the following statements are true about the FILESTREAM argument of SQL Server 2008?

If a table contains FILESTREAM data and the table is partitioned, the FILESTREAM_ON clause must be included.

The FILESTREAM column can be partitioned even if a table is not partitioned.

There may not be a FILESTREAM filegroup if a table is not partitioned and the FILESTREAM_ON clause is not specified.

The filegroup in the FILESTREAM_ON <filegroup>> clause must have one file defined for the filegroup.

Answer

Correct Answer: If a table contains FILESTREAM data and the table is partitioned, the FILESTREAM_ON clause must be included.

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