The IT Certification Resource Center

Featured Deal

Get CompTIA, Cisco, and Microsoft training courses free for a week.
Learn More ❯

MCSA SQL Server 2008 Practice Quiz: 70-432 Quiz 1

Question 2:

You manage a default Microsoft SQL Server 2008 instance.

The Inventory database contains a schema named SKU owned by dbo. Several database objects are contained in the schema.

You need to transfer ownership of the schema to InvData_owner. You need to do this with minimal administrative effort and with minimal interference with database operations.

What should you do?

A. Run ALTER AUTHORIZATION
B. Run ALTER SCHEMA
C. Run ALTER USER
D. Run DROP SCHEMA and CREATE SCHEMA