11. You need to store images in for a Web site using SQL Server 2008. How can
you accomplish this?
A. Use a FileStream data type, and the images will be stored on disk
B. Use a varchar data type and store the images in that field
C. Use an int data type and store the images in that field
D. Use an nchar data type and store the images in that field
The correct answer is A. The FileStream data type is meant for storing files on
disk. You could also store the image in a varbinary field, but moving forward
the recommended approach is to use the FileStream data type.
Answers B, C, and D all reference data types that cannot be used to store
binary data like image files. One approach is to use a varchar field as a pointer
to the disk, but this is not recommended after the introduction of the
FileStream data type.
Bạn đang xem 11. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P141 DOC