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.

GRANT UPDATE ON Invoices TO PaymentEntry;

GRANT CRUD ON Invoices TO PaymentEntry;

ALTER ROLE db_datareader ADD MEMBER PaymentEntry;

CREATE ROLE PaymentEntry;

GRANT READ ON Invoices TO PaymentEntry;

GRANT INSERT,UPDATE ON InvoiceLineItems TO PaymentEntry;

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

set the role to inactive

take the database offline

remove all users from this role

redirect all logins to the Public role

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

		dynamic SQL
		user-defined encryption
		AES
		transparent data encryption