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

A If a table contains FILESTREAM data and the table is partitioned, the FILESTREAM_ON clause must be included. 
B The FILESTREAM column can be partitioned even if a table is not partitioned. 
C There may not be a FILESTREAM filegroup if a table is not partitioned and the FILESTREAM_ON clause is not specified. 
D The filegroup in the FILESTREAM_ON <filegroup>> clause must have one file defined for the filegroup. 

+ Answer
A D 

+ Report

Mohammad Towhidul Islam

Editor, VCampus

Your Name

Your Email

Type of Report
Spelling MistakeIncorrect AnswerGrammar MistakeContent MissingImproper Text FormatInsufficient AnswerDuplicate QuestionImproper Sentence StructureImproper Equation/FormulaOther

Description