unit 9

Question 1

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

Answer 1

uniqueidentifier

Question 2

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?

an SqlFileStream object

the GET_FILESTREAM_TRANSACTION_CONTEXT function

the PathName function

a SafeFileHandle object

Answer 2

a SafeFileHandle object

Question 3

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

The BLOB is backed up with the database.

The BLOB must be smaller than 2GB.

The BLOB access is as fast as file system access.

Database security can be used to control access to the BLOB.

Answer 3

The BLOB must be smaller than 2GB.

Question 4

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

Answer 4

FILESTREAM

Question 5

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

Answer 5

PathName

Question 6

You should use FILESTREAM storage when

Answer 6

most of the BLOBs in the column are larger than 1MB

fast read access is critical to the application

Question 7

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

Answer 7

ROWGUIDCOL

Question 8

What should you use to retrieve binary data?

Answer 8

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

Question 9

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

Answer 9

GUID (globally unique identifer)

Question 10

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

Answer 10

varbinary(max)

Question 11

By default, FILESTREAM storage is ________________ for the server.

Answer 11

disabled

Question 12

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

Answer 12

file group

Question 13

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

Answer 13

binary

Question 14

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

Answer 14

NEWID

Question 15

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.

Answer 15

pointer