1.The users, groups, logins, and roles that have access to a server are called ______________________________.

2.To allow users to log on using either type of authentication, you need to set the SQL Server authentication mode to ______________________________ mode.

3.To create a user-defined database role, you use the _________________________ statement.

4.To log on to SQL Server using your SQL Server login ID, you use ______________________________ authentication.

5.To log on to SQL Server using your Windows login ID, you use ______________________________ authentication.

6.To transfer a database object from one schema to another, you use the ______________________________ statement.

7.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 is it?

a. an SqlFileStream object

b. the PathName function

c. a SafeFileHandle object

d.the GET_FILESTREAM_TRANSACTION_CONTEXT function

8.Users who are involved in the administration of the server are typically assigned to one of the ______________________________ roles that are built into SQL Server.

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

a. NEWID

b. ROWGUIDCOL

c.PathName

d. GUID

10. What is the command that is used to give permissions to the Create statements?

11.When multiple database objects access each other sequentially, the sequence is known as a _____.

12. When you create a table that includes a column for storing BLOBs, you can enable FILESTREAM storage for the column by coding the __________________ attribute for that column.

13. You can code one or more ______________________________ within the start tag of an element.

14. You can encrypt data without modifying applications by using _____.

15. You can store a BLOB value in a column of the ____________________ data type.

16. You can use the ______________________________ to create an XML Schema Definition for an XML document.

17. The _________ statement can be used to remove granted permissions, and the __________ statement can be used to prevent a principal from gaining a specific permission through a GRANT.