1.

Write a script that uses the XML document shown below to update the contact information in the Vendors table.

Stanley Henry Ono Santa

2.

Pick all that apply.

Write a script that

Creates a user-defined database role name PaymentEntry in the AP database.

Give Update permission to the new role for the Invoices table.

Give Update and Insert permission for the InvoiceLineItems.

Give Select permission for all user tables.

A		GRANT INSERT,UPDATE ON InvoiceLineItems TO PaymentEntry;
B		GRANT UPDATE ON Invoices TO PaymentEntry;
C		GRANT READ ON Invoices TO PaymentEntry;
D		GRANT CRUD ON Invoices TO PaymentEntry;
E		ALTER ROLE db_datareader ADD MEMBER PaymentEntry;
F		CREATE ROLE PaymentEntry;

Before you can drop the user-defined database role named PaymentEntry, you must ____

set the role to inactive

redirect all logins to public role

take the database offline

remove all users from this role

Starting with SQL Server 2008, _____ makes it easy to encrypt the entire database without affecting existing applications.

dynamic SQL

AES

transparent data encryption

user-defined encryption