YOU NEED TO STORE IMAGES IN FOR A WEB SITE USING SQL SERVER 2008....

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.