Sign in to save your progress, vote, and build your own decks.Sign in
SQL Server 2008 Exam 70 432 - Chapt 4
71 cards·by jdawsonj
What is a principal?
An entity that can request SQL Server recources
What level is a Windows domain login principal?
A Windows level
What level is a Windows local login principal?
A Windows level
What level is a Windows group principal?
A Windows level
What level does a SQL Sever login principal belong to?
SQL Server level
What level does a SQL Server login mapped to a Windows login principal belong to?
SQL Server level
What level does a SQL Sever login mapped to a certificate principal belong to?
SQL Server level
What level does a SQL Sever login mapped to an asymmetric key principal belong to?
SQL Server level
What level does a Database user principal belong to?
Database level
What level does a Database user mapped to a SQL Server login principal belong to?
Database level
What level does a Database user mapped to a Windows login principal belong to?
Database level
What level does a Database user mapped to a certificate principal belong to?
Database level
What level does a Database user mapped to an asymmetric key principal belong to?
Database level
What level does a Database role principal belong to?
Database level
What level does a Application role principal belong to?
Database level
What level does a Public role principal belong to?
Database level
What is the Server hierarchy of securable objects in SQL Sever 2008?
Database
What are the 2 roles provided by SQL Server?
Server-level role and Database-level role
To what hierarchy of securable objects in SQL Server does 'database' belong to?
Server
To what hierarchy of securable objects in SQL Server does 'SQL Server login' belong to?
Server
To what hierarchy of securable objects in SQL Server does 'endpoint' belong to?
Server
To what hierarchy of securable objects in SQL Server does 'remote binding' belong to?
Server
To what hierarchy of securable objects in SQL Server does 'route' belong to?
Server
To what hierarchy of securable objects in SQL Server does 'application role' belong to?
Database
To what hierarchy of securable objects in SQL Server does 'assembly' belong to?
Database
To what hierarchy of securable objects in SQL Server does 'asymmetric key' belong to?
Database
To what hierarchy of securable objects in SQL Server does 'certificate' belong to?
Database
To what hierarchy of securable objects in SQL Server does 'database user' belong to?
Database
To what hierarchy of securable objects in SQL Server does 'fixed database role' belong to?
Database
To what hierarchy of securable objects in SQL Server does 'full text catalog' belong to?
Database
To what hierarchy of securable objects in SQL Server does 'message type' belong to?
Database
To what hierarchy of securable objects in SQL Server does 'service' belong to?
Database
To what hierarchy of securable objects in SQL Server does 'service contact' belong to?
Database
To what hierarchy of securable objects in SQL Server does 'symetric key' belong to?
Database
To what hierarchy of securable objects in SQL Server does 'default' belong to?
Schema
To what hierarchy of securable objects in SQL Server does 'function' belong to?
Schema
To what hierarchy of securable objects in SQL Server does 'procedure' belong to?
Schema
To what hierarchy of securable objects in SQL Server does 'query stats' belong to?
Schema
To what hierarchy of securable objects in SQL Server does 'queue' belong to?
Schema
To what hierarchy of securable objects in SQL Server does 'rule' belong to?
Schema
To what hierarchy of securable objects in SQL Server does 'synonym' belong to?
Schema
To what hierarchy of securable objects in SQL Server does 'table' belong to?
Schema
To what hierarchy of securable objects in SQL Server does 'trigger' belong to?
Schema
To what hierarchy of securable objects in SQL Server does 'type' belong to?
Schema
To what hierarchy of securable objects in SQL Server does 'view' belong to?
Schema
To what hierarchy of securable objects in SQL Server does 'XML Schema collection' belong to?
Schema
What do Server level roles provide?
They are fixed roles that have a server-wide permission scope
What do Database level roles provide?
They are user created roles that can be built to suit more specific needs
To what level role does the 'sysadmin' belong to?
Server
To what level role does the 'serveradmin' belong to?
Server
To what level role does the 'securityadmin' belong to?
Server
To what level role does the 'processadmin' belong to?
Server
To what level role does the 'setupadmin' belong to?
Server
To what level role does the 'bulkadmin' belong to?
Server
To what level role does the 'diskadmin' belong to?
Server
To what level role does the 'dbcreator' belong to?
Server
What does the 'sysadmin' role provide?
Can perform any activity in the server
What does the 'serveradmin' role provide?
Can change server-wide config options and shut down the server
What does the 'securityadmin' role provide?
Manage logins and their properties. Able to reset passwords and GRANT, DENY, and Revoke
database-level and server-level permissions
What does the 'processadmin' role provide?
Can end processes running in an instance of SQL Server
What does the 'setupadmin' role provide?
Can add and remove linked servers
What does the 'bulkadmin' role provide?
Can run the BULK INSERT statement
What does the 'dbadmin' role provide?
Can manage disk files
What does the 'dbcreator' role provide?
Can CREATE
What does the 'sp_helpsrvrole' object do?
Returns a list of server-level roles
What does the 'sp_helpsrvrolemember' object do?
Returns information about the members of a server-level role
What does the 'sp_srvrolepermission' object do?
Displays the permissions of a server-level role
What does the 'IS_SRVROLEMEMBER' object do?
Indicates whether a SQL Server login is a member of specified server-level role
What does the 'sys.server_role_members' object do?
Adds login as member of a server-level role
What does the 'sp_addsrvrole_member' object do?
Removes login as a member of a server-level role
What does the 'sp_dropsrvrole_member' object do?