Which statement(s) about user and roles are true?

You are a database administrator on an instance of SQL Server 2008. You create two database schemas using the following Transact-SQL statements:
CREATE SCHEMA Schema1; CREATE SCHEMA Schema2 AUTHORIZATION DevUser;
You create User1 with a default schema of Schema2. Assuming defaults and no other assigned permissions, which statement(s) about user and roles are true?
(Choose all that apply.)
A. User1 can create tables in Schema2.
B. DevUser can drop Schema2 if it contains no database objects.
C. DevUser can drop any objects that have been created in Schema2.
D. DevUser can create database objects in Schema2.
E. DevUser can copy objects in Schema2 to Schema1.

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.