Unit 9

When you create a table that includes a column for storing BLOBs, which attribute can you code to enable FILESTREAM storage for the column?

FILESTREAM

A ________________ is a value that's unique within the current database and other networked versions of the database around the world.

GUID(globally unique identifier)

What SQL Server function can you use to generate a globally unique value?

NEWID

To be able to use FILESTREAM storage, which format is required for the drive that stores the files?

NTFS

Which function can you use to return the path to the binary file stream?

PathName

To define a column that contains a GUID, you specify which property for the column?

ROWGUIDCOL

When you store a BLOB in a database column with FILESTREAM storage, which of the following statements is not true?

The BLOB must be smaller than 2GB

What should you use to retrieve binary data?

a SELECT statement just as you would for other types of data

To work with the data in a column that uses FILESTREAM storage from a .NET application, you must use all but one of the following. Which one?

a SafeFileHandle object

You should use FILESTREAM storage when

most of the BLOBS in the column are larger than 1MB fast read access is critical to the application

One way to work with binary data is to use a varchar column to store a string value that acts as a _______________ to a binary file.

pointer

Which data type do you use to define a column that contains a GUID?

uniqueidentifier

You can store a BLOB value in a column of which data type?

varbinary(max)

A BLOB can be used to store large amounts of what kind of data?

binary

By default, FILESTREAM storage is ________________ for the server.

disabled

Before you can use FILESTREAM storage, you must use the CREATE DATABASE statement to create a _____________ to provide for FILESTREAM storage.

file group