COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Global admin role
|
|
|
Db backupoperator fixed role
|
|
|
Db owner fixed role
|
|
|
Dbo fixed role
|
Detailed explanation-1: -Members of the db accessadmin fixed database role can add or remove access to the database for Windows logins, Windows groups, and SQL Server logins. Members of the db backupoperator fixed database role can back up the database.
Detailed explanation-2: -The dbo user is a special user principal in each database. All SQL Server administrators, members of the sysadmin fixed server role, sa login, and owners of the database, enter databases as the dbo user. The dbo user has all permissions in the database and cannot be limited or dropped.
Detailed explanation-3: -Fixed server roles include bulkadmin, dbcreator, diskadmin, processadmin, securityadmin, serveradmin, setupadmin, and sysadmin. Each of these roles has a specific purpose, but in general these tasks allow their members to perform administrative or maintenance duties at the server level.
Detailed explanation-4: -Members of the sysadmin fixed server role can perform any activity in the server. Members of the serveradmin fixed server role can change server-wide configuration options and shut down the server. Members of the securityadmin fixed server role manage logins and their properties.