Which fixed database role allows members to execute all database data definition language commands?

Options

  • A. db_ddladmin
  • B. db_datareader
  • C. db_backupoperator
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

A. db_ddladmin

Detailed Explanation

  • db_ddladmin: Allows members to run all DDL commands in a database.
  • DDL: Includes commands such as CREATE, ALTER and DROP.
  • It is used for managing database object definitions.