You work as a senior database administrator at ABC.com. The ABC.com network consists of a
single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their
environment.
You are running a training exercise for Microsoft SQL Server 2012 junior administrators. You are
discussing what the purpose of assigning the db_owner fixed database-level role to a user.
Which of the following is TRUE with regards to this discussion?
A.
It allows the user to perform all configuration and maintenance activities on the database, and
can also drop the database.
B.
It allows the user to modify role membership and manage permissions.
C.
It allows the user to add or remove access to the database for Windows logins.
D.
It allows the user to run any Data Definition Language (DDL) command in a database.
Explanation: