202 Multiple choice questions

1. Restore specific files or filegroups to a database.
   1. Recovery only ???
   2. Bulk-Logged ???
   3. File restore ???
   4. Page restore ???
2. hierarchical structure
   1. A particularly powerful permissions organization technique is to design a ___ of standard database roles.
   2. Granting permission means that a user can ___
   3. A user may have multiple permission ___ to an object (e.g., individually, through a standard database role, and through the public role). If any of these ___ are denied, then the user is blocked from accessing the object.
   4. You cannot modify the permissions assigned to a ___
3. • Overwrite the existing database.
   • Preserve the replication settings.
   • Prompt before restoring each backup.
   • Restrict access to the restored database.
   1. In the Restore options panel, you can choose any of the following options : ___
   2. Steps to modify an object's permissions: ___
   3. A permission is used to grant an entity access to an ___
   4. The most common login method involves supplying a ___
4. a granted permission.
   1. Denying permission overrides ___
   2. Object permission: Execute ???
   3. The assigned permission may be ___
   4. Object permission: Select ???
5. denied permissions
   1. The sysadmin role can perform any ___ in the SQL Server installation, regardless of any other permission setting. The sysadmin role even overrides denied permissions on an object.
   2. The sysadmin role is a powerful one, and you must be sure not to grant it to the ___ user login.
   3. The sysadmin role can perform any activity in the SQL Server installation, regardless of any other permission setting. The sysadmin role even overrides ___ on an object.
   4. Restore scenarios possible in SQL Server include the following: ___
6. login side
   1. You can manage database access from either the login side or the ___
   2. To grant access from the database point of view, use the ___ under the Database > Security > Users node to open the Database User-New form.
   3. You can manage database access from either the ___ or the database side.
   4. Create a mirror database ???
7. overwrite
   1. A Transact-SQL command to grant database access to a user: ___
   2. Differential backup only backs up data since ___
   3. You can append new backups to any existing backups on a device, or you can ___ any existing backups.
   4. You cannot modify the permissions assigned to a ___
8. Recovers data that is already consistent with the database and needs only to be made available.
   1. Piecemeal restore ???
   2. Partial restore ???
   3. Recovery only ???
   4. A login or logon is ___
9. GRANT All ON Contacts TO dbcreator
   1. Grants all permissions to the «public role» for the Contacts table:
   2. Object permissions are assigned with the SQL DCL commands: ___
   3. To add a user to a «database role», follow these steps:
   4. The following code creates the manager role:
10. sp_addrole
    1. Transact-SQL command to drop user: ___
    2. To add a user to a «database role», follow these steps:
    3. An incremental backup contains only the data that has changed since the ___
    4. In Transact-SQL code, you can add a user to a fixed database role by using the ___ system stored procedure.
11. CREATE USER [LRN]
    FROM LOGIN [WS2008\cbastiao]
    1. A permission is used to grant an entity access to an ___
    2. A Transact-SQL command to grant database access to a user: ___
    3. A local user account cannot be used outside the ___
    4. Transactions that are running during the backup are never ___
12. assign or check object permissions.
    1. Piecemeal restore ???
    2. The Securables page is used to ___
    3. Authentication is the act of ___
    4. An incremental backup is based on the ___
13. database objects
    1. Deny permission always has a higher priority than the ___
    2. Object permissions are permissions that allow a user to act on ___ , such as tables, stored procedures, and views.
    3. Object permissions are assigned with the SQL DCL commands GRANT, ___
    4. Granting permission means that a user can ___
14. last backup of the data.
    1. An incremental backup is based on the ___
    2. Granting object permission interacts with ___
    3. Differential file backups ???
    4. Complete database restore ???
15. Can create, alter, drop, and restore databases.
    1. Fixed server role: Dbcreator ???
    2. Fixed server role: Diskadmin ???
    3. File restore ???
    4. Fixed server role: Processadmin ???
16. mixed mode
    1. Windows Authentication mode is superior to ___ because users don't need to learn yet another password and because it leverages the security design of the network.
    2. Using Windows Authentication means that users must have a ___ in order to be recognized by SQL Server
    3. You cannot modify ___ to a fixed server role.
    4. A Windows login can be removed from SQL Server through SSMS...this doesn't
       delete the user from ___ ; it only removes the user from SQL Server.
17. may exist.
    1. fixed database role: «db_securityadmin» ???
    2. Revert a database to the point in time captured by a ___
    3. A user may have multiple permission paths to an object (e.g., ___ ). If any of these paths are denied, then the user is blocked from accessing the object.
    4. Users may be assigned to multiple roles, so multiple security paths from a user to an object ___
18. tables, stored procedures, and views.
    1. Revoking a permission removes the permission that has been assigned, regardless of whether it was a ___ permission.
    2. Instead of granting the permission to a user from the properties of the object, you can also grant permissions to an object from the ___
    3. A permission is used to grant an entity access to an ___
    4. Object permissions are permissions that allow a user to act on database objects, such as ___
19. GRANT Select, Update ON Emails to Guest, LRN
    1. The db_owner is a special role that has ___
    2. The following code creates the manager role:
    3. The following code grants select and update permission to the guest user and to LRN:
    4. The following code grants select permission to Joe for the Emails table:
20. EXEC sp_addsrvrolemember 'XPS\Lauren', 'sysadmin'
    1. the following code adds the user login ''XPS\Lauren'' to the sysadmin role: ___
    2. Revert a database to the point in time captured by a ___
    3. The following code grants select permission to Joe for the Emails table:
    4. You cannot modify the permissions assigned to a ___
21. Windows authentication or SQL Server authentication.
    1. A SQL Server login account and related passwords are defined on the SQL server and are not related to ___
    2. SQL servers also support mixed mode, which allows you to connect to a SQL server using ___
    3. Types of partial backups supported by SQL Server: ___
    4. Once users exist in the Windows user list or the Windows domain, SQL Server can ___
22. granting
    1. Object permissions are assigned with the SQL DCL commands GRANT, ___
    2. Each object's permission is assigned through ___ , denying, or revoking user login permissions.
    3. Each object's permission is assigned through granting, denying, or ___ user login permissions.
    4. Each object's permission is assigned by ___
23. ALL, SELECT, INSERT, DELETE, REFERENCES, UPDATE, or EXECUTE.
    1. The Securables page is used to ___
    2. The assigned permission may be ___
    3. Create a mirror database ???
    4. A login or logon is ___
24. Complete database restore, File restore, Page restore, Piecemeal restore, Recovery only, Transaction log restore, Create a mirror database, Create and maintain a standby server.
    1. The disadvantages of Full Recovery mode is that the logs ___
    2. The Securables page is used to ___
    3. Restore scenarios possible in SQL Server include the following: ___
    4. Fixed server roles are set in SSMS in the Server Roles page of the ___
25. any tables.
    1. Domain user account is the recommended login account because the SQL Server can then use the ___ specifically created for it.
    2. Granting permission means that a user can ___
    3. Fixed server roles are set in SSMS in the Server Roles page of the ___
    4. Ownership chains are great for developing tight security where users execute stored procedures but aren't granted direct permission to ___
26. affect entire rows.
    1. Each object's permission is assigned by ___
    2. Only select and update permissions can be set at the column level, because inserts
       and deletes ___
    3. Granting permission means that a user can ___
    4. Differential base or base of the differential ???
27. DROP ROLE Manager
    1. Remove the role from the database
    2. Piecemeal restore ???
    3. Recovery only ???
    4. Create a mirror database ???
28. Authorizes a user to issue DDL commands (create, alter, drop).
    1. File restore ???
    2. fixed database role: «db_ddladmin» ???
    3. Fixed server role: Securityadmin ???
    4. fixed database role: «db_owner» ???
29. establishing or confirming a user or system identity.
    1. A user account is ___
    2. Ownership chains apply to ___
    3. Authentication is the act of ___
    4. A login or logon is ___
30. ownership
    1. ___ always has a higher priority than the Grant permission.
    2. SQL Server includes fixed, predefined server roles. Primarily, these roles grant permission to ___
    3. The db_owner is a special role that has ___
    4. Within SQL Server, users are assigned to roles, which may in turn grant permission to objects... each object has an owner, and ___ also affects permissions.
31. specific database functions
    1. Incremental backups are smaller and faster than ___
    2. Domain users are managed with tools such as the ___
    3. user-defined roles are typically employed for users who need to perform ___ but to whom you don't want to grant a role that would permit them do more than what they need to.
    4. SQL Server includes ___ . Primarily, these roles grant permission to perform certain server-related administrative tasks.
32. append
    1. Types of database backups supported by SQL Server: ___
    2. You can manage database access from either the ___ or the database side.
    3. You can ___ new backups to any existing backups on a device, or you can overwrite any existing backups.
    4. Generically, to restore the database using the specified file, you would execute the following command: ___
33. Allows a user to perform backups, checkpoints, and DBCC commands,
    but not restores (Only server sysadmins can perform restores.)
    1. fixed database role: «db_denydatawriter» ???
    2. fixed database role: «db_backupoperator» ???
    3. fixed database role: «db_denydatareader» ???
    4. fixed database role: «db_datareader» ???
34. Restore specific pages to a database.
    1. A user account is ___
    2. Page restore ???
    3. Transaction log restore ???
    4. Recovery only ???
35. Granting object permission
    1. Usually, a differential base is ___
    2. The db_owner is a special role that has ___
    3. Authentication is the act of ___
    4. ___ interacts with the server and database roles.
36. delayed
    1. Revert a database to the point in time captured by a ___
    2. Authentication is the act of ___
    3. Transact-SQL command to drop user: ___
    4. Transactions that are running during the backup are never ___
37. Windows user groups.
    1. Because SQL Authentication is less secure than Windows logins, avoiding mixed mode is ___ ; however, it is available for backward compatibility.
    2. The counterpart to creating a role is removing it. A role may not be dropped if any users are currently ___ to it.
    3. Windows Authentication mode is superior to ___ because users don't need to learn yet another password and because it leverages the security design of the network.
    4. Windows Authentication is very robust in that it will authenticate not only Windows users, but also users within ___
38. • By adding the role to the user in the user's Database User Properties form (Database » Security » Users » Properties of user )
    • By adding the user to the role in the Database Role Properties dialog (Database » Security » Roles » Database Roles » Properties of role)
    1. fixed database role: «db_denydatareader» ???
    2. Each object's permission is assigned through ___ , denying, or revoking user login permissions.
    3. «Fixed database roles» can be assigned via SSMS using either of the following procedures: ___
    4. The disadvantages of Full Recovery mode is that the logs ___
39. fixed roles, the public role, and user-defined roles.
    1. Authentication is the act of ___
    2. Removes a user from an assigned role:
    3. The Securables page is used to ___
    4. There are three kinds of database server roles: ___
40. A user «cannot» read from any table in the database. This overrides any object-level grant.
    1. fixed database role: «db_denydatareader» ???
    2. fixed database role: «db_securityadmin» ???
    3. Fixed server role: Securityadmin ???
    4. fixed database role: «db_accessadmin» ???
41. access the object.
    1. Transact-SQL command to drop user: ___
    2. Object permission: DRI (References) ???
    3. Granting permission means that a user can ___
    4. Authentication is the act of ___
42. RESTORE DATABASE AdventureWorks FROM DISK = 'C:\AventureWorks.BAK'
    1. To restore the AdventureWorks database using the C:\AdventureWorks.BAK backup, you would execute the following command: ___
    2. Generically, to restore the database using the specified file, you would execute the following command: ___
    3. In SQL Server, «fixed database roles» include the following:
    4. Differential database backups ???
43. the permissions assigned
    1. The Windows SID (___) is passed to SQL Server.
    2. Removes a user from an assigned role:
    3. Complete database restore ???
    4. You cannot modify ___ to a fixed server role.
44. A backup of all the full data in the primary filegroup, every read/write filegroup, and any optionally specified read-only files or filegroups. A partial backup of a read-only database contains only the primary filegroup.
    1. Partial backup ???
    2. Full backup: ___
    3. Page restore ???
    4. File backup ???
45. server environment.
    1. A local user account cannot be used outside the ___
    2. The guest user account is not actually created when a___
    3. A login or logon is ___
    4. Local users can be managed by selecting ___
46. Allows good performance while using the least log space.
    1. A login or logon is ___
    2. File backup ???
    3. Database backup ???
    4. Bulk-Logged ???
47. Login Properties dialog box.
    1. Fixed server roles are set in SSMS in the Server Roles page of the ___
    2. Fixed server role: Setupadmin ???
    3. Fixed server role: Processadmin ???
    4. Object permissions are assigned with the SQL DCL commands: ___
48. views, stored procedures, and user-defined functions.
    1. Partial restore ???
    2. Authentication is the act of ___
    3. Object permission: Execute ???
    4. Ownership chains apply to ___
49. rights and permissions
    1. It is important to be aware of the ___ associated with each object in a database because it's possible to inadvertently grant administrative rights to objects or users that should not have them.
    2. Revert a database to the point in time captured by a ___
    3. To grant access to a database from the login side using Object Explorer, use the User Mapping page of the ___.
    4. Domain users are managed with tools such as the ___
50. accessing the object.
    1. The Transact-SQL statement to provide permission to an object for a specific user and his or her role is as follows:
    2. A permission is used to grant an entity access to an ___
    3. The ___ is used to assign or check object permissions.
    4. A user may have multiple permission paths to an object (e.g., individually, through a standard database role, and through the public role). If any of these paths are denied, then the user is blocked from ___
51. public role
    1. The ___ is a fixed role, but it can have object permissions like a standard role. Every user is automatically a member of the ___ and cannot be removed, so the ____ serves as a baseline or minimum permission level.
    2. Several specific types of object permissions exist: ___
    3. You cannot modify the permissions assigned to a ___
    4. ___ interacts with the server and database roles.
52. risk for a security breach.
    1. There are three kinds of database server roles: ___
    2. Any user who wishes to access a database but who has not been declared a user within the database is ___
    3. Guest users must be removed from a database when they are no longer welcome, as they are a ___
    4. In the security model for a SQL Server, there are three different methods by which a user can be initially identified: ___
53. Partial backup & Differential partial backup
    1. Types of partial backups supported by SQL Server: ___
    2. Types of database backups supported by SQL Server: ___
    3. Partial restore ???
    4. An incremental backup is based on the ___
54. last full or incremental backup.
    1. An incremental backup contains only the data that has changed since the ___
    2. Local users can be managed by selecting ___
    3. A local user account cannot be used outside the ___
    4. The guest user account is ___ when a database is created;
55. DROP LOGIN command
    1. To remove a Windows user or group from SQL Server, you can also use the ___
    2. ___ interacts with the server and database roles.
    3. Remove the role from the database
    4. Types of partial backups supported by SQL Server: ___
56. Under the full or bulk-logged recovery model, since the logs record each transaction, restoring from log backups is required to reach a desired recovery point.
    1. Fixed server role: Diskadmin ???
    2. Authentication is the act of ___
    3. Transaction log restore ???
    4. Object permission: Execute ???
57. Can perform any activity in the SQL Server installation, regardless of any other permission setting. The sysadmin role even overrides denied permissions on an object.
    1. Fixed server role: Sysadmin ???
    2. Fixed server role: Processadmin ???
    3. Object permission: Select ???
    4. Fixed server role: Setupadmin ???
58. granting, revoking, or denying user login permissions.
    1. Granting object permission interacts with ___
    2. Each object's permission is assigned by ___
    3. Object permission: Insert ???
    4. Object permission: Select ???
59. individually, through a standard database role, and through the public role
    1. Each object's permission is assigned by ___
    2. If a user does not have the ___ , the highest level object permission would be the Grant and Deny object permissions.
    3. A user may have multiple permission paths to an object (e.g., ___ ). If any of these paths are denied, then the user is blocked from accessing the object.
    4. A particularly powerful permissions organization technique is to design a ___ of standard database roles.
60. File backup & Differential file backups
    1. Types of file backups supported by SQL Server: ___
    2. Backups that SQL Server supports: ???
    3. There are three kinds of database server roles: ___
    4. A local user account cannot be used outside the ___
61. transactions that are running;
    1. Differential backup only backs up data since ___
    2. Granting permission means that a user can ___
    3. An incremental backup is based on the ___
    4. Performing a backup operation has minimal effect on ___
62. not actually created
    1. The guest user account is not actually created when a___
    2. A user account is ___
    3. The guest user account is ___ when a database is created;
    4. A local user account cannot be used outside the ___
63. • Simple Recovery
    • Full Recovery
    • Bulk-Logged
    1. Domain users are managed with tools such as the ___
    2. You cannot modify the permissions assigned to a ___
    3. SQL Server offers three recovery models for each database. They are: ___
    4. Types of file backups supported by SQL Server: ___
64. full backups and differential backups.
    1. Authentication is the act of ___
    2. Removes a user from an assigned role:
    3. Differential backup only backs up data since ___
    4. Incremental backups are smaller and faster than ___
65. Restore an entire database from a full database backup.
    1. Page restore ???
    2. Partial restore ???
    3. File restore ???
    4. Complete restore ???
66. Grant and Deny object permissions.
    1. If a user does not have the sysadmin server role, the highest level object permission would be the ___
    2. If a user does not have the ___ , the highest level object permission would be the Grant and Deny object permissions.
    3. SQL Server includes fixed, predefined server roles. Primarily, these roles grant permission to ___
    4. To add a user to a «database role», follow these steps:
67. properties of the object
    1. You cannot modify the permissions assigned to a ___
    2. To remove a Windows user or group from SQL Server, you can also use the ___
    3. if you add a user to the sysadmin role, that user now has ___ for that server.
    4. Instead of granting the permission to a user from the ___ , you can also grant permissions to an object from the properties of the user.
68. paths
    1. A user may have multiple permission ___ to an object (e.g., individually, through a standard database role, and through the public role). If any of these ___ are denied, then the user is blocked from accessing the object.
    2. The following code grants select permission to Joe for the Emails table:
    3. If a user does not have the ___ , the highest level object permission would be the Grant and Deny object permissions.
    4. The Transact-SQL statement to provide permission to an object for a specific user and his or her role is as follows:
69. recognize them.
    1. You can perform a SQL Server backup with minimal effect on ___
    2. Once users exist in the Windows user list or the Windows domain, SQL Server can ___
    3. The Windows SID (___) is passed to SQL Server.
    4. Object permissions are assigned with the SQL DCL commands: ___
70. activity
    1. The Windows SID (___) is passed to SQL Server.
    2. You cannot modify ___ to a fixed server role.
    3. ___ interacts with the server and database roles.
    4. The sysadmin role can perform any ___ in the SQL Server installation, regardless of any other permission setting. The sysadmin role even overrides denied permissions on an object.
71. backup devices.
    1. Grants all permissions to the «public role» for the Contacts table:
    2. The one user that SQL Server automatically creates during installation of the software is ___
    3. During a backup operation, SQL Server copies the data directly from the database files to the ___
    4. File backups should be used only where they clearly add value to your ___
72. database side.
    1. A local user account cannot be used outside the ___
    2. Incremental backups are smaller and faster than ___
    3. You can manage database access from either the login side or the ___
    4. You can manage database access from either the ___ or the database side.
73. differential base.
    1. An incremental backup contains only the data that has changed since the ___
    2. Types of file backups supported by SQL Server: ___
    3. A differential backup contains only the data that has changed since the ___
    4. Incremental backups are smaller and faster than ___
74. predefined server roles
    1. The ___ is used to assign or check object permissions.
    2. Removes a user from an assigned role:
    3. SQL Server includes ___ . Primarily, these roles grant permission to perform certain server-related administrative tasks.
    4. SQL Server offers three recovery models for each database. They are: ___
75. security identifier
    1. Create and maintain a standby server ???
    2. The Securables page is used to ___
    3. The following code creates the manager role:
    4. The Windows SID (___) is passed to SQL Server.
76. GRANT Select ON Emails TO Joe
    1. The following code grants select permission to Joe for the Emails table:
    2. The db_owner is a special role that has ___
    3. The ___ is a special role that has all permissions in the database.
    4. You cannot modify the permissions assigned to a ___
77. The right to delete existing data.
    1. Object permission: Select ???
    2. Object permission: Delete ???
    3. Object permission: Insert ???
    4. Recovery only ???
78. Grant permission.
    1. Granting permission means that a user can ___
    2. Domain users are managed with tools such as the ___
    3. Incremental backups are smaller and faster than ___
    4. Deny permission always has a higher priority than the ___
79. database snapshot.
    1. Types of database backups supported by SQL Server: ___
    2. Revert a database to the point in time captured by a ___
    3. fixed database role: «db_securityadmin» ???
    4. A permission is used to grant an entity access to an ___
80. perform certain server-related administrative tasks.
    1. ___ interacts with the server and database roles.
    2. SQL Server includes fixed, predefined server roles. Primarily, these roles grant permission to ___
    3. To add a user to a «database role», follow these steps:
    4. Fixed server role: Processadmin ???
81. all permissions in the database.
    1. Denying permission overrides ___
    2. The Securables page is used to ___
    3. The db_owner is a special role that has ___
    4. Ownership chains apply to ___
82. fixed server role.
    1. Granting object permission interacts with ___
    2. Object permission: Select ???
    3. You cannot modify ___ to a fixed server role.
    4. You cannot modify the permissions assigned to a ___
83. A backup that contains only the data that were modified since the most recent partial backup of the same set of filegroups.
    1. Partial restore ???
    2. Differential file backups ???
    3. File restore ???
    4. Differential partial backup ???
84. sysadmin server role
    1. A user may have multiple permission ___ to an object (e.g., individually, through a standard database role, and through the public role). If any of these ___ are denied, then the user is blocked from accessing the object.
    2. If a user does not have the ___ , the highest level object permission would be the Grant and Deny object permissions.
    3. To grant access to a database from the login side using Object Explorer, use the ___ of the Login Properties form.
    4. Several specific types of object permissions exist: ___
85. any user in that group.
    1. Local users can be managed by selecting ___
    2. Guest users must be removed from a database when they are no longer welcome, as they are a ___
    3. Each object's permission is assigned through granting, denying, or ___ user login permissions.
    4. Access, roles, and permissions can be assigned to the Windows user group, and they will apply to ___
86. The right to create foreign keys.
    1. Object permission: Delete ???
    2. Object permission: Update ???
    3. Object permission: DRI (References) ???
    4. Object permission: Insert ???
87. properties of the user.
    1. Object permissions are permissions that allow a user to act on database objects, such as ___
    2. Granting permission means that a user can ___
    3. Revoking a permission ___ the permission that has been assigned, regardless of whether it was a denied permission or a granted permission.
    4. Instead of granting the permission to a user from the properties of the object, you can also grant permissions to an object from the ___
88. Restores a file or filegroup in a multi-filegroup database. After a full file restore, a differential file backup can be restored.
    1. File restore ???
    2. Bulk-Logged ???
    3. Page restore ???
    4. Recovery only ???
89. valid Windows account
    1. Because SQL Authentication is less secure than Windows logins, avoiding mixed mode is ___ ; however, it is available for backward compatibility.
    2. Authentication is the act of ___
    3. if you add a user to the sysadmin role, that user now has ___ for that server.
    4. Using Windows Authentication means that users must have a ___ in order to be recognized by SQL Server
90. user-defined roles.
    1. There are three kinds of database server roles: fixed roles, the public role, and ___
    2. The disadvantages of Full Recovery mode is that the logs ___
    3. Object permissions are assigned with the SQL DCL commands: ___
    4. The most common login method involves supplying a ___
91. Restores an entire database, beginning with a full database backup, which may be followed by restoring a differential database backup (and log backups).
    1. Fixed server role: Dbcreator ???
    2. Piecemeal restore ???
    3. Differential database backups ???
    4. Complete database restore ???
92. A full backup of all the data in one or more files or filegroups.
    1. Piecemeal restore ???
    2. Database backup ???
    3. Complete restore ???
    4. File backup ???
93. A backup of all files in the database. This backup contains only the data that were modified since the most recent database backup of each file.
    1. Usually, a differential base is ___
    2. Differential database backups ???
    3. Page restore ???
    4. Partial restore ???
94. a baseline or minimum permission level.
    1. The following code sample assigns Joe to the manager role:
    2. The following code creates the manager role:
    3. A permission is used to grant an entity access to an ___
    4. The public role is a fixed role, but it can have object permissions like a standard role. Every user is automatically a member of the public role and cannot be removed, so the public role serves as ___
95. Local user account, Local system account, Domain user account.
    1. Types of database backups supported by SQL Server: ___
    2. The guest user account is not actually created when a___
    3. Three different types of accounts are available for the SQL Server service account: ___
    4. Fixed server roles are set in SSMS in the Server Roles page of the ___
96. Can configure linked servers, extended stored procedures, and the startup stored procedure.
    1. Fixed server role: Setupadmin ???
    2. File restore ???
    3. Fixed server role: Processadmin ???
    4. fixed database role: «db_securityadmin» ???
97. Active Directory or Windows accounts.
    1. Performing a backup operation has minimal effect on ___
    2. SQL servers also support mixed mode, which allows you to connect to a SQL server using ___
    3. A SQL Server login account and related passwords are defined on the SQL server and are not related to ___
    4. Because SQL Server is an environment within the Windows Server system, one of your primary security concerns should be ensuring that the Windows Server itself is ___
98. sysadmin role
    1. Restore scenarios possible in SQL Server include the following: ___
    2. Revoking a permission ___ the permission that has been assigned, regardless of whether it was a denied permission or a granted permission.
    3. The ___ can perform any activity in the SQL Server installation, regardless of any other permission setting. The ___ even overrides denied permissions on an object.
    4. The sysadmin role can perform any activity in the SQL Server installation, regardless of any other permission setting. The sysadmin role even overrides ___ on an object.
99. db_accessadmin,
    db_backupoperator,
    db_datareader,
    db_datawriter,
    db_ddladmin,
    db_denydatareader,
    db_denydatawriter,
    db_owner,
    db_securityadmin.
    1. In SQL Server, «fixed database roles» include the following:
    2. fixed database role: «db_datareader» ???
    3. Fixed server role: Dbcreator ???
    4. Differential database backups ???
100. SQL authentication.
     1. The «sa account» is the built-in SQL administrator account associated with ___
     2. Transactions that are running during the backup are never ___
     3. The guest user account is ___ when a database is created;
     4. Users must be explicitly granted access to ___
101. database is created;
     1. A user account is ___
     2. The assigned permission may be ___
     3. The db_owner is a special role that has ___
     4. The guest user account is not actually created when a___
102. object.
     1. A permission is used to grant an entity access to an ___
     2. Revert a database to the point in time captured by a ___
     3. Users must be explicitly granted access to ___
     4. The purpose of a database backup is ___
103. New User Context Menu command
     1. To grant access to a database from the login side using Object Explorer, use the ___ of the Login Properties form.
     2. Transactions that are running during the backup are never ___
     3. The ___ is a special role that has all permissions in the database.
     4. To grant access from the database point of view, use the ___ under the Database > Security > Users node to open the Database User-New form.
104. Deny permission
     1. Removes a user from an assigned role:
     2. ___ always has a higher priority than the Grant permission.
     3. ___ interacts with the server and database roles.
     4. The ___ is used to assign or check object permissions.
105. Can perform bulk insert operations.
     1. Fixed server role: Sysadmin ???
     2. Fixed server role: Setupadmin ???
     3. Fixed server role: Bulkadmin ???
     4. Fixed server role: Diskadmin ???
106. • Windows user login
     • Membership in a Windows user group
     • SQL Server-specific login (if the server uses mixed-mode security)
     1. In the security model for a SQL Server, there are three different methods by which a user can be initially identified: ___
     2. The sysadmin role is a powerful one, and you must be sure not to grant it to the ___ user login.
     3. The disadvantages of Full Recovery mode is that the logs ___
     4. The BUILTINS/Administrators user can be deleted or ___
107. BUILTINS/Administrator
     1. The Transact-SQL RESTORE command enables you to perform the following restore scenarios: ___
     2. You can perform a SQL Server backup with minimal effect on ___
     3. The one user that SQL Server automatically creates during installation of the software is ___
     4. The sysadmin role can perform any ___ in the SQL Server installation, regardless of any other permission setting. The sysadmin role even overrides denied permissions on an object.
108. Restores a database in stages, beginning with the primary filegroup and one or more secondary filegroups.
     1. Partial restore ???
     2. Piecemeal restore ???
     3. Page restore ???
     4. File restore ???
109. full access to every server function, database, and object
     1. If you add a user to the sysadmin role group, that user must reconnect to the SQL Server instance in order for the full capabilities of ___
     2. if you add a user to the sysadmin role, that user now has ___ for that server.
     3. Domain users are managed with tools such as the ___
     4. Revert a database to the point in time captured by a ___
110. Contains all the data in a specific database or set of filegroups or files to allow recovering that data.
     1. Bulk-Logged ???
     2. Partial restore ???
     3. Full backup: ___
     4. Partial backup ???
111. user account
     1. There are three kinds of database server roles: ___
     2. Create and maintain a standby server ???
     3. A ___ is a logical representation of a person within an electronic system.
     4. The Windows SID (___) is passed to SQL Server.
112. A backup of one or more files that contain data extents that were changed since the most recent full backup of each file.
     1. Differential file backups ???
     2. Fixed server role: Sysadmin ???
     3. Transaction log restore ???
     4. Piecemeal restore ???
113. full backup must be created
     1. You can manage database access from either the ___ or the database side.
     2. fixed database role: «db_denydatareader» ???
     3. A permission is used to grant an entity access to an ___
     4. Over time, as a database is updated, the amount of data that is included in differential backups increases. This makes the backup slower to create and to restore. Eventually, another ___ to provide a new differential base for another series of differential backups.
114. Windows account
     1. A local user account cannot be used outside the ___
     2. A SQL Server login account and related passwords are defined on the SQL server and are not related to ___
     3. Once users exist in the Windows user list or the Windows domain, SQL Server can ___
     4. Domain user account is the recommended login account because the SQL Server can then use the ___ specifically created for it.
115. server login name.
     1. Types of database backups supported by SQL Server: ___
     2. You can manage database access from either the login side or the ___
     3. To remove Lauren's database access, the system-stored procedure DROP USER requires her database username, not her ___
     4. Transact-SQL command to drop user: ___
116. CREATE ROLE Manager
     1. The Securables page is used to ___
     2. The following code creates the manager role:
     3. You cannot modify ___ to a fixed server role.
     4. The purpose of a database backup is ___
117. When information is written to one server, it is automatically replicated to the second server.
     1. Object permission: Update ???
     2. Create a mirror database ???
     3. Object permission: Delete ???
     4. Page restore ???
118. Database backup & Differential database backups
     1. Types of database backups supported by SQL Server: ___
     2. Local users can be managed by selecting ___
     3. An incremental backup is based on the ___
     4. Differential backup only backs up data since ___
119. least administration
     1. It is important to be aware of the ___ associated with each object in a database because it's possible to inadvertently grant administrative rights to objects or users that should not have them.
     2. ___ only backs up data since the last full backup.
     3. Simple Recovery requires the ___ since the transaction log backups are truncated on a regular basis.
     4. SQL Server offers three recovery models for each database. They are: ___
120. Login Properties form
     1. Revert a database to the point in time captured by a ___
     2. To grant access to a database from the login side using Object Explorer, use the User Mapping page of the ___.
     3. To grant access to a database from the login side using Object Explorer, use the ___ of the Login Properties form.
     4. If a user does not have the ___ , the highest level object permission would be the Grant and Deny object permissions.
121. db_owner
     1. Several specific types of object permissions exist: ___
     2. The following code grants select permission to Joe for the Emails table:
     3. The ___ is a special role that has all permissions in the database.
     4. You can manage database access from either the ___ or the database side.
122. Securables page
     1. The ___ is used to assign or check object permissions.
     2. The purpose of a database backup is ___
     3. ___ always has a higher priority than the Grant permission.
     4. The db_owner is a special role that has ___
123. Authorizes a user to read all data in the database. This role is the equivalent of a grant on all objects, and it can be overridden by a deny permission.
     1. fixed database role: «db_datawriter» ???
     2. fixed database role: «db_backupoperator» ???
     3. fixed database role: «db_datareader» ???
     4. fixed database role: «db_denydatawriter» ???
124. standby
     1. To add a user to a «database role», follow these steps:
     2. A permission is used to grant an entity access to an ___
     3. Incremental backups are smaller and faster than ___
     4. When you have a ___ server, you are using an active-passive cluster that consists of two or more servers.
125. When the active server fails, the passive server will become the active server, allowing for minimum downtime.
     1. Create and maintain a standby server ???
     2. Differential partial backup ???
     3. Differential database backups ???
     4. Object permission: Update ???
126. the server and database roles.
     1. An incremental backup is based on the ___
     2. Users must be explicitly granted access to ___
     3. Each object's permission is assigned by ___
     4. Granting object permission interacts with ___
127. SSMS »» database »» open the object to manage (tables, views, stored procedure, functions) »» Properties »» Click the Permissions page »» add user/role »» Select the appropriate Grant to Deny permission.
     1. The db_owner is a special role that has ___
     2. The purpose of a database backup is ___
     3. Steps to modify an object's permissions: ___
     4. Granting object permission interacts with ___
128. secure.
     1. Because SQL Server is an environment within the Windows Server system, one of your primary security concerns should be ensuring that the Windows Server itself is ___
     2. Because SQL Authentication is less secure than Windows logins, avoiding mixed mode is ___ ; however, it is available for backward compatibility.
     3. Fixed server roles are set in SSMS in the Server Roles page of the ___
     4. Domain users are managed with tools such as the ___
129. Windows
     1. To remove a Windows user or group from SQL Server, you can also use the ___
     2. A Windows login can be removed from SQL Server through SSMS...this doesn't
        delete the user from ___ ; it only removes the user from SQL Server.
     3. A ___ is a logical representation of a person within an electronic system.
     4. The following code sample assigns Joe to the manager role:
130. backward compatibility.
     1. Each object's permission is assigned through ___ , denying, or revoking user login permissions.
     2. Because SQL Authentication is less secure than Windows logins, avoiding mixed mode is recommended; however, it is available for ___
     3. Regardless of an organization's size, the end result of its ___ should be to ensure that users' assigned rights and responsibilities are enforced through a security plan.
     4. You can manage database access from either the login side or the ___
131. recommended
     1. You can manage database access from either the login side or the ___
     2. Because SQL Authentication is less secure than Windows logins, avoiding mixed mode is recommended; however, it is available for ___
     3. Access, roles, and permissions can be assigned to the Windows user group, and they will apply to ___
     4. Because SQL Authentication is less secure than Windows logins, avoiding mixed mode is ___ ; however, it is available for backward compatibility.
132. Restore part of a database.
     1. Partial restore ???
     2. File restore ???
     3. Recovery only ???
     4. Complete database restore ???
133. Control Panel > Administrative Tools > Computer Management.
     1. Fixed server role: Diskadmin ???
     2. Local users can be managed by selecting ___
     3. Full Recovery allows you to ___
     4. A local user account cannot be used outside the ___
134. Can manage the logins for the server.
     1. Fixed server role: Securityadmin ???
     2. Fixed server role: Sysadmin ???
     3. Fixed server role: Setupadmin ???
     4. Fixed server role: Diskadmin ???
135. username and password.
     1. Transact-SQL command to drop user: ___
     2. The db_owner is a special role that has ___
     3. Steps to modify an object's permissions: ___
     4. The most common login method involves supplying a ___
136. Restore a transaction log onto a database.
     1. Partial backup ???
     2. File restore ???
     3. Transaction log restore ???
     4. Piecemeal restore ???
137. Permits a user to manage database-level security - including roles and
     permissions.
     1. fixed database role: «db_securityadmin» ???
     2. fixed database role: «db_backupoperator» ???
     3. fixed database role: «db_ddladmin» ???
     4. fixed database role: «db_accessadmin» ???
138. the sysadmin role to take effect.
     1. If a user does not have the sysadmin server role, the highest level object permission would be the ___
     2. If you add a user to the sysadmin role group, that user must reconnect to the SQL Server instance in order for the full capabilities of ___
     3. To add a user to a «database role», follow these steps:
     4. You cannot modify the permissions assigned to a ___
139. CREATE LOGIN [WS2008\CBASTIAO] FROM WINDOWS
     1. Create and maintain a standby server ???
     2. The ___ is a special role that has all permissions in the database.
     3. Transact-SQL syntax so that you can add the windows username: cbastiao from domain name: WS2008
     4. Transactions that are running during the backup are never ___
140. 1. SSMS »» expand the database folder »» Security folder »» Roles »» Database Roles folder.
     2. Double-click the appropriate role to open the Database Role Properties dialog box.
     3. Add or remove users from the role.
     1. Create a mirror database ???
     2. fixed database role: «db_datareader» ???
     3. fixed database role: «db_owner» ???
     4. To add a user to a «database role», follow these steps:
141. modified as desired after installation.
     1. The Securables page is used to ___
     2. The BUILTINS/Administrators user can be deleted or ___
     3. Create and maintain a standby server ???
     4. The db_owner is a special role that has ___
142. database objects
     1. To add a user to a «database role», follow these steps:
     2. Even though a user may belong to a fixed database role and have certain administrative level permissions, he or she still cannot access data without first being granted permission to ___ (e.g., tables, stored procedures, views, functions).
     3. fixed database role: «db_accessadmin» ???
     4. In SQL Server, «fixed database roles» include the following:
143. application to gain access regardless of the user.
     1. Granting object permission interacts with ___
     2. The disadvantages of Full Recovery mode is that the logs ___
     3. Revert a database to the point in time captured by a ___
     4. An application role is a database-specific role intended to allow an ___
144. This is a special role that has all permissions in the database. This role includes all the capabilities of the other roles and differs from the dbo user role. This is not the database-level equivalent of the server sysadmin role because an object-level deny will override membership in this role.
     1. fixed database role: «db_denydatawriter» ???
     2. fixed database role: «db_datareader» ???
     3. fixed database role: «db_denydatareader» ???
     4. fixed database role: «db_owner» ???
145. DROP USER userTeste
     1. Transaction log restore ???
     2. Transact-SQL command to drop user: ___
     3. The Securables page is used to ___
     4. A Transact-SQL command to grant database access to a user: ___
146. roles
     1. Object permissions are assigned with the SQL DCL commands GRANT, ___
     2. Within SQL Server, users are assigned to roles, which may in turn ___ permission to objects... each object has an owner, and ownership also affects permissions.
     3. Within SQL Server, users are assigned to roles, which may in turn grant ___ ... each object has an owner, and ownership also affects permissions.
     4. Within SQL Server, users are assigned to ___, which may in turn grant permission to objects... each object has an owner, and ownership also affects permissions.
147. restore to a point in time since the logs files record all SQL transactions and the time they were performed.
     1. File restore ???
     2. A login or logon is ___
     3. Recovery only ???
     4. Full Recovery allows you to ___
148. "guest"
     1. It is possible for users who have not been granted direct access to a database to gain access using the ___ user account - and with this account, they can make limited changes within the database server.
     2. If a user does not have the ___ , the highest level object permission would be the Grant and Deny object permissions.
     3. Local users can be managed by selecting ___
     4. Domain users are managed with tools such as the ___
149. Blocks a user from modifying data in any table in the database. This overrides any object-level grant.
     1. fixed database role: «db_denydatareader» ???
     2. fixed database role: «db_backupoperator» ???
     3. fixed database role: «db_denydatawriter» ???
     4. fixed database role: «db_ddladmin» ???
150. a logical representation of a person within an electronic system.
     1. File restore ???
     2. Complete restore ???
     3. Page restore ???
     4. A user account is ___
151. the last full backup.
     1. Differential file backups ???
     2. Granting permission means that a user can ___
     3. The purpose of a database backup is ___
     4. Differential backup only backs up data since ___
152. Restores individual pages.
     1. Page restore ???
     2. Recovery only ???
     3. Bulk-Logged ???
     4. File restore ???
153. Expand Databases »» Right-click the database, point to Tasks, then click Restore »» Database »» the name of the restoring database appears in the To database list box. To create a new database, enter its name in the list box (etc)
     1. Restore scenarios possible in SQL Server include the following: ___
     2. Types of partial backups supported by SQL Server: ___
     3. To restore data through the graphical interface tool, follow these steps: ___
     4. To add a user to a «database role», follow these steps:
154. Can create, alter, and drop disk files.
     1. fixed database role: «db_owner» ???
     2. Fixed server role: Diskadmin ???
     3. Object permission: Select ???
     4. Complete database restore ???
155. the guest user account has been created.
     1. Any user who wishes to access a database but who has not been declared a user within the database is automatically granted the privileges of the guest user, as long as ___
     2. The BUILTINS/Administrators user can be deleted or ___
     3. At the SQL Server level, where the database resides, users are known by their ___ . This can be a SQL Server login, a Windows domain login, or a username login.
     4. The following code sample assigns Joe to the manager role:
156. login names
     1. Guest users must be removed from a database when they are no longer welcome, as they are a ___
     2. At the SQL Server level, where the database resides, users are known by their ___ . This can be a SQL Server login, a Windows domain login, or a username login.
     3. To grant access from the database point of view, use the ___ under the Database > Security > Users node to open the Database User-New form.
     4. There are three kinds of database server roles: ___
157. to have something to restore if data is lost during a business's daily routine.
     1. A login or logon is ___
     2. The purpose of a database backup is ___
     3. Remove the role from the database
     4. Complete database restore ???
158. database security
     1. Steps to modify an object's permissions: ___
     2. A permission is used to grant an entity access to an ___
     3. Regardless of an organization's size, the end result of its ___ should be to ensure that users' assigned rights and responsibilities are enforced through a security plan.
     4. Types of partial backups supported by SQL Server: ___
159. The right to modify existing data. Update rights for which a WHERE clause is
     used require select rights as well. Update permission can be set on specific columns.
     1. Object permission: Update ???
     2. Denying permission overrides ___
     3. Object permission: Delete ???
     4. File restore ???
160. grant
     1. Within SQL Server, users are assigned to ___, which may in turn grant permission to objects... each object has an owner, and ownership also affects permissions.
     2. Within SQL Server, users are assigned to roles, which may in turn grant ___ ... each object has an owner, and ownership also affects permissions.
     3. Within SQL Server, users are assigned to roles, which may in turn grant permission to objects... each object has an owner, and ___ also affects permissions.
     4. Within SQL Server, users are assigned to roles, which may in turn ___ permission to objects... each object has an owner, and ownership also affects permissions.
161. GRANT Permission, Permission
     ON Object
     TO User/role, User/role
     WITH GRANT OPTION
     1. The Transact-SQL statement to provide permission to an object for a specific user and his or her role is as follows:
     2. A Transact-SQL command to grant database access to a user: ___
     3. The assigned permission may be ___
     4. To grant access to a database from the login side using Object Explorer, use the User Mapping page of the ___.
162. Allows a user to write to all data in the database. This role is the equivalent of a grant on all objects, and it can be overridden by a deny permission.
     1. fixed database role: «db_backupoperator» ???
     2. File restore ???
     3. fixed database role: «db_datawriter» ???
     4. Fixed server role: Setupadmin ???
163. CREATE ROLE auditors AUTHORIZATION db_securityadmin;
     1. fixed database role: «db_denydatareader» ???
     2. Creates the «database role» AUDITORS, which is owned by the «db_securityadmin» «fixed database role»:
     3. At restore time, the full backup is restored ___, followed by the most recent differential backup.
     4. fixed database role: «db_datareader» ???
164. any user database.
     1. Usually, a differential base is ___
     2. A permission is used to grant an entity access to an ___
     3. Users must be explicitly granted access to ___
     4. Authentication is the act of ___
165. Authorizes a user to access the database, but not to manage database level security.
     1. Complete database restore ???
     2. fixed database role: «db_securityadmin» ???
     3. Fixed server role: Dbcreator ???
     4. fixed database role: «db_accessadmin» ???
166. Latest full backup of the data
     1. Differential base or base of the differential ???
     2. fixed database role: «db_datawriter» ???
     3. fixed database role: «db_owner» ???
     4. Fixed server role: Dbcreator ???
167. assigned
     1. The BUILTINS/Administrators user can be deleted or ___
     2. The counterpart to creating a role is removing it. A role may not be dropped if any users are currently ___ to it.
     3. There are three kinds of database server roles: fixed roles, the public role, and ___
     4. Remove the role from the database
168. application role
     1. An application role is a database-specific role intended to allow an ___
     2. An ___ is a database-specific role intended to allow an application to gain access regardless of the user.
     3. Over time, as a database is updated, the amount of data that is included in differential backups increases. This makes the backup slower to create and to restore. Eventually, another ___ to provide a new differential base for another series of differential backups.
     4. fixed database role: «db_accessadmin» ???
169. GRANT, REVOKE, and DENY.
     1. Object permissions are assigned with the SQL DCL commands GRANT, ___
     2. Granting permission means that a user can ___
     3. Object permission: Execute ???
     4. Object permissions are assigned with the SQL DCL commands: ___
170. production workloads.
     1. Differential backup only backs up data since ___
     2. You can perform a SQL Server backup with minimal effect on ___
     3. You cannot modify the permissions assigned to a ___
     4. Local users can be managed by selecting ___
171. can grow a lot.
     1. The assigned permission may be ___
     2. Types of database backups supported by SQL Server: ___
     3. The db_owner is a special role that has ___
     4. The disadvantages of Full Recovery mode is that the logs ___
172. User Mapping page
     1. To add a user to a «database role», follow these steps:
     2. To grant access from the database point of view, use the ___ under the Database > Security > Users node to open the Database User-New form.
     3. To grant access to a database from the login side using Object Explorer, use the ___ of the Login Properties form.
     4. You can manage database access from either the login side or the ___
173. first
     1. To restore data through the graphical interface tool, follow these steps: ___
     2. Types of database backups supported by SQL Server: ___
     3. At restore time, the ___ , followed by each incremental backup following the full backup.
     4. At restore time, the full backup is restored ___, followed by the most recent differential backup.
174. The right to select data. Select permission can be applied to specific columns.
     1. Object permission: Update ???
     2. Page restore ???
     3. Object permission: Select ???
     4. Fixed server role: Setupadmin ???
175. full backup is restored first
     1. At restore time, the ___ , followed by each incremental backup following the full backup.
     2. At restore time, the full backup is restored ___, followed by the most recent differential backup.
     3. To restore data through the graphical interface tool, follow these steps: ___
     4. Simple Recovery requires the ___ since the transaction log backups are truncated on a regular basis.
176. The right to insert data.
     1. Object permission: Delete ???
     2. Object permission: Execute ???
     3. Page restore ???
     4. Object permission: Insert ???
177. REVOKE, and DENY.
     1. The assigned permission may be ___
     2. Granting permission means that a user can ___
     3. Object permission: Insert ???
     4. Object permissions are assigned with the SQL DCL commands GRANT, ___
178. CREATE LOGIN command.
     1. To create a login using Transact-SQL syntax so that you can add a Windows user or group run the ___
     2. Granting permission means that a user can ___
     3. The ___ is used to assign or check object permissions.
     4. Transact-SQL syntax so that you can add the windows username: cbastiao from domain name: WS2008
179. denied or a granted
     1. Revoking a permission removes the permission that has been assigned, regardless of whether it was a ___ permission.
     2. Revoking a permission ___ the permission that has been assigned, regardless of whether it was a denied permission or a granted permission.
     3. Granting permission means that a user can ___
     4. You cannot modify the permissions assigned to a ___
180. the process by which individual access to a computer system is controlled by identification of the user through the credentials he or she provides.
     1. A login or logon is ___
     2. Ownership chains apply to ___
     3. Bulk-Logged ???
     4. File backup ???
181. A full backup of the whole database.
     1. Database backup ???
     2. Create a mirror database ???
     3. File restore ???
     4. Full backup: ___
182. • Restore an entire database from a full database backup.
     • Restore part of a database.
     • Restore specific files or filegroups to a database.
     • Restore specific pages to a database.
     • Restore a transaction log onto a database.
     • Revert a database to the point in time.
     1. You can manage database access from either the login side or the ___
     2. Transactions that are running during the backup are never ___
     3. The Transact-SQL RESTORE command enables you to perform the following restore scenarios: ___
     4. In Transact-SQL code, you can add a user to a fixed database role by using the ___ system stored procedure.
183. RESTORE DATABASE name_of_database FROM DISK = 'name of backup'
     1. Guest users must be removed from a database when they are no longer welcome, as they are a ___
     2. Types of database backups supported by SQL Server: ___
     3. Generically, to restore the database using the specified file, you would execute the following command: ___
     4. An application role is a database-specific role intended to allow an ___
184. more than what they need to.
     1. Differential base or base of the differential ???
     2. user-defined roles are typically employed for users who need to perform specific database functions but to whom you don't want to grant a role that would permit them do ___
     3. SQL Server includes ___ . Primarily, these roles grant permission to perform certain server-related administrative tasks.
     4. The ___ is used to assign or check object permissions.
185. automatically granted the privileges of the guest user, as long as the guest user account has been created.
     1. Any user who wishes to access a database but who has not been declared a user within the database is ___
     2. Revert a database to the point in time captured by a ___
     3. In SQL Server, «fixed database roles» include the following:
     4. There are three kinds of database server roles: ___
186. EXEC sp_dropRoleMember Manager, Joe
     1. Removes a user from an assigned role:
     2. Remove the role from the database
     3. Create a mirror database ???
     4. Complete restore ???
187. Can kill a running SQL Server process.
     1. File restore ???
     2. Fixed server role: Processadmin ???
     3. fixed database role: «db_ddladmin» ???
     4. Object permission: Update ???
188. revoking
     1. Each object's permission is assigned through ___ , denying, or revoking user login permissions.
     2. «Fixed database roles» can be assigned via SSMS using either of the following procedures: ___
     3. Instead of granting the permission to a user from the ___ , you can also grant permissions to an object from the properties of the user.
     4. Each object's permission is assigned through granting, denying, or ___ user login permissions.
189. EXEC sp_addrolemember Manager, Joe
     1. The following code sample assigns Joe to the manager role:
     2. Remove the role from the database
     3. The following code grants select permission to Joe for the Emails table:
     4. ___ interacts with the server and database roles.
190. The right to execute stored procedures or user-defined functions.
     1. Object permission: Execute ???
     2. File restore ???
     3. Object permission: Insert ???
     4. Recovery only ???
191. Active Directory Users and Computers snap-in.
     1. Ownership chains apply to ___
     2. The assigned permission may be ___
     3. Granting object permission interacts with ___
     4. Domain users are managed with tools such as the ___
192. Can configure the server-wide settings, including setting up full-text searches and shutting down the server.
     1. Complete restore ???
     2. fixed database role: «db_accessadmin» ???
     3. Fixed server role: Serveradmin ???
     4. File restore ???
193. Full, differential, and incremental backups.
     1. Page restore ???
     2. Transaction log restore ???
     3. Backups that SQL Server supports: ???
     4. Complete database restore ???
194. denying
     1. Object permission: Delete ???
     2. Object permission: DRI (References) ???
     3. Each object's permission is assigned through granting, ___ , or revoking user login permissions.
     4. You cannot modify the permissions assigned to a ___
195. Select, Insert, Update, Delete, DRI (References), Execute
     1. There are three kinds of database server roles: ___
     2. Object permission: Insert ???
     3. The assigned permission may be ___
     4. Several specific types of object permissions exist: ___
196. removes
     1. Granting permission means that a user can ___
     2. Revoking a permission ___ the permission that has been assigned, regardless of whether it was a denied permission or a granted permission.
     3. A permission is used to grant an entity access to an ___
     4. You cannot modify the permissions assigned to a ___
197. wrong
     1. The disadvantages of Full Recovery mode is that the logs ___
     2. A local user account cannot be used outside the ___
     3. The sysadmin role is a powerful one, and you must be sure not to grant it to the ___ user login.
     4. The following code sample assigns Joe to the manager role:
198. Differential backup
     1. The purpose of a database backup is ___
     2. Incremental backups are smaller and faster than ___
     3. Authentication is the act of ___
     4. ___ only backs up data since the last full backup.
199. permission to objects
     1. In SQL Server, «fixed database roles» include the following:
     2. Within SQL Server, users are assigned to roles, which may in turn grant ___ ... each object has an owner, and ownership also affects permissions.
     3. Object permissions are assigned with the SQL DCL commands: ___
     4. The ___ is used to assign or check object permissions.
200. mirror database
     1. ___ interacts with the server and database roles.
     2. When you have a ___ , you have duplicate databases on multiple servers.
     3. Create and maintain a standby server ???
     4. The purpose of a database backup is ___
201. restore plan.
     1. A differential backup contains only the data that has changed since the ___
     2. The Securables page is used to ___
     3. File backups should be used only where they clearly add value to your ___
     4. The disadvantages of Full Recovery mode is that the logs ___
202. used by several successive differential backups.
     1. The Securables page is used to ___
     2. Usually, a differential base is ___
     3. Transaction log restore ???
     4. Partial restore ???