Question types

Start with

Question limit

of 202 available terms

Print test

202 Multiple choice questions

  1. Restore specific files or filegroups to a database.
  2. hierarchical structure
  3. • Overwrite the existing database.
    • Preserve the replication settings.
    • Prompt before restoring each backup.
    • Restrict access to the restored database.
  4. a granted permission.
  5. denied permissions
  6. login side
  7. overwrite
  8. Recovers data that is already consistent with the database and needs only to be made available.
  9. GRANT All ON Contacts TO dbcreator
  10. sp_addrole
    FROM LOGIN [WS2008\cbastiao]
  12. assign or check object permissions.
  13. database objects
  14. last backup of the data.
  15. Can create, alter, drop, and restore databases.
  16. mixed mode
  17. may exist.
  18. tables, stored procedures, and views.
  19. GRANT Select, Update ON Emails to Guest, LRN
  20. EXEC sp_addsrvrolemember 'XPS\Lauren', 'sysadmin'
  21. Windows authentication or SQL Server authentication.
  22. granting
  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.
  25. any tables.
  26. affect entire rows.
  27. DROP ROLE Manager
  28. Authorizes a user to issue DDL commands (create, alter, drop).
  29. establishing or confirming a user or system identity.
  30. ownership
  31. specific database functions
  32. append
  33. Allows a user to perform backups, checkpoints, and DBCC commands,
    but not restores (Only server sysadmins can perform restores.)
  34. Restore specific pages to a database.
  35. Granting object permission
  36. delayed
  37. Windows user groups.
  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)
  39. fixed roles, the public role, and user-defined roles.
  40. A user «cannot» read from any table in the database. This overrides any object-level grant.
  41. access the object.
  42. RESTORE DATABASE AdventureWorks FROM DISK = 'C:\AventureWorks.BAK'
  43. the permissions assigned
  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.
  45. server environment.
  46. Allows good performance while using the least log space.
  47. Login Properties dialog box.
  48. views, stored procedures, and user-defined functions.
  49. rights and permissions
  50. accessing the object.
  51. public role
  52. risk for a security breach.
  53. Partial backup & Differential partial backup
  54. last full or incremental backup.
  55. DROP LOGIN command
  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.
  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.
  58. granting, revoking, or denying user login permissions.
  59. individually, through a standard database role, and through the public role
  60. File backup & Differential file backups
  61. transactions that are running;
  62. not actually created
  63. • Simple Recovery
    • Full Recovery
    • Bulk-Logged
  64. full backups and differential backups.
  65. Restore an entire database from a full database backup.
  66. Grant and Deny object permissions.
  67. properties of the object
  68. paths
  69. recognize them.
  70. activity
  71. backup devices.
  72. database side.
  73. differential base.
  74. predefined server roles
  75. security identifier
  76. GRANT Select ON Emails TO Joe
  77. The right to delete existing data.
  78. Grant permission.
  79. database snapshot.
  80. perform certain server-related administrative tasks.
  81. all permissions in the database.
  82. fixed server role.
  83. A backup that contains only the data that were modified since the most recent partial backup of the same set of filegroups.
  84. sysadmin server role
  85. any user in that group.
  86. The right to create foreign keys.
  87. properties of the user.
  88. Restores a file or filegroup in a multi-filegroup database. After a full file restore, a differential file backup can be restored.
  89. valid Windows account
  90. user-defined roles.
  91. Restores an entire database, beginning with a full database backup, which may be followed by restoring a differential database backup (and log backups).
  92. A full backup of all the data in one or more files or filegroups.
  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.
  94. a baseline or minimum permission level.
  95. Local user account, Local system account, Domain user account.
  96. Can configure linked servers, extended stored procedures, and the startup stored procedure.
  97. Active Directory or Windows accounts.
  98. sysadmin role
  99. db_accessadmin,
  100. SQL authentication.
  101. database is created;
  102. object.
  103. New User Context Menu command
  104. Deny permission
  105. Can perform bulk insert operations.
  106. • Windows user login
    • Membership in a Windows user group
    • SQL Server-specific login (if the server uses mixed-mode security)
  107. BUILTINS/Administrator
  108. Restores a database in stages, beginning with the primary filegroup and one or more secondary filegroups.
  109. full access to every server function, database, and object
  110. Contains all the data in a specific database or set of filegroups or files to allow recovering that data.
  111. user account
  112. A backup of one or more files that contain data extents that were changed since the most recent full backup of each file.
  113. full backup must be created
  114. Windows account
  115. server login name.
  116. CREATE ROLE Manager
  117. When information is written to one server, it is automatically replicated to the second server.
  118. Database backup & Differential database backups
  119. least administration
  120. Login Properties form
  121. db_owner
  122. Securables page
  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.
  124. standby
  125. When the active server fails, the passive server will become the active server, allowing for minimum downtime.
  126. the server and database roles.
  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.
  128. secure.
  129. Windows
  130. backward compatibility.
  131. recommended
  132. Restore part of a database.
  133. Control Panel > Administrative Tools > Computer Management.
  134. Can manage the logins for the server.
  135. username and password.
  136. Restore a transaction log onto a database.
  137. Permits a user to manage database-level security - including roles and
  138. the sysadmin role to take effect.
  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.
  141. modified as desired after installation.
  142. database objects
  143. application to gain access regardless of the user.
  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.
  145. DROP USER userTeste
  146. roles
  147. restore to a point in time since the logs files record all SQL transactions and the time they were performed.
  148. "guest"
  149. Blocks a user from modifying data in any table in the database. This overrides any object-level grant.
  150. a logical representation of a person within an electronic system.
  151. the last full backup.
  152. Restores individual pages.
  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)
  154. Can create, alter, and drop disk files.
  155. the guest user account has been created.
  156. login names
  157. to have something to restore if data is lost during a business's daily routine.
  158. database security
  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.
  160. grant
  161. GRANT Permission, Permission
    ON Object
    TO User/role, User/role
  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.
  163. CREATE ROLE auditors AUTHORIZATION db_securityadmin;
  164. any user database.
  165. Authorizes a user to access the database, but not to manage database level security.
  166. Latest full backup of the data
  167. assigned
  168. application role
  169. GRANT, REVOKE, and DENY.
  170. production workloads.
  171. can grow a lot.
  172. User Mapping page
  173. first
  174. The right to select data. Select permission can be applied to specific columns.
  175. full backup is restored first
  176. The right to insert data.
  177. REVOKE, and DENY.
  178. CREATE LOGIN command.
  179. denied or a granted
  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.
  181. A full backup of the whole database.
  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.
  183. RESTORE DATABASE name_of_database FROM DISK = 'name of backup'
  184. more than what they need to.
  185. automatically granted the privileges of the guest user, as long as the guest user account has been created.
  186. EXEC sp_dropRoleMember Manager, Joe
  187. Can kill a running SQL Server process.
  188. revoking
  189. EXEC sp_addrolemember Manager, Joe
  190. The right to execute stored procedures or user-defined functions.
  191. Active Directory Users and Computers snap-in.
  192. Can configure the server-wide settings, including setting up full-text searches and shutting down the server.
  193. Full, differential, and incremental backups.
  194. denying
  195. Select, Insert, Update, Delete, DRI (References), Execute
  196. removes
  197. wrong
  198. Differential backup
  199. permission to objects
  200. mirror database
  201. restore plan.
  202. used by several successive differential backups.