NAME

Question types


Start with


Question limit

of 270 available terms

Print test

270 True/False questions

  1. Database Engine, expand one fileWhen all the files in a filegroup are full, the ____ will automatically ____ at a time.

          

  2. Bulk update locksUsed to use update locks instead of shared locks when you read a table, and then hold the locks until the end of the transaction.

          

  3. User databaseUsed by the SQL Server Agent to schedule alerts and jobs.

          

  4. One, groupUsed to lock the table.

          

  5. NOT NULLUsed to NOT issue any shared locks or recognize exclusive locks. Use only with the SELECT statement.

          

  6. SQL Server's FilegroupsRecords events as they occur. Through a trace you can look at the commands that have been executed against the database.

          

  7. Profiler, deadlock eventsYou can use SQL Server ____ to identify the cause by tracing ____.

          

  8. Index scanTakes place when SQL Server needs to scan the index pages to find the records

          

  9. Unique IndexA non-clustered index optimized with a filter predicate to index only a portion of rows in a table.

          

  10. Lock TimeoutsTell the number of lock requests per second that timed out including NOWAIT locks.

          

  11. UPDLOCKOnly one transaction can obtain this to a resource at any point in time.

          

  12. Normal Data CardinalityData values are uncommon and never unique

          

  13. TSQL_Replay templateCollects information relevant for tuning SQL Server's performance.

          

  14. Simple modelAllows concurrent transactions to SELECT a resource under pessimistic concurrency control. During an update a transaction will attempt to change to an exclusive lock.

          

  15. Model databaseA workspace for holding temporary objects and result sets.

          

  16. READUNCOMMITTEDSame as NOLOCK: Used to NOT issue any shared locks or recognize exclusive locks.

          

  17. May not, BACKUPYou ____ add or remove files when ____ is running.

          

  18. Global temporary tablesCollects information relevant for tuning SQL Server's performance.

          

  19. File or filegroup, databaseA database that is isolated from other databases and the instance of SQL Server that hosts it.

          

  20. 2012, partiallyThe ratio of qualifying rows to total rows. When low the index is highly selected.

          

  21. ConstraintsUsed to define how the integrity of your database can be enforced automatically.

          

  22. Char, default____, worker threads, memory, parallel query execution-related resources and Multiple Active Results Sets resources can all cause ____.

          

  23. sys.backup_devices
    sys.database_files
    sys.database_mirroring
    sys.database_recovery_status
    sys.databases
    sys.master_files
    The views related to databases and files are ____.

          

  24. XLOCKOnline Analytical Processing, requires fast read and computation on the fly.

          

  25. File, single filegroupA ____ can only be a member of a ____.

          

  26. full, model databaseUsed by the SQL Server Agent to schedule alerts and jobs.

          

  27. stored procedure, DROP TABLEAll temporary tables will be automatically dropped when the ____ is finished or via the ____ command.

          

  28. Cannot, uncompressed, media setYou ____ keep compressed and ____ backups in the same ____.

          

  29. FragmentationExists when your indexes have pages in which the logical ordering does not match the physical ordering inside the physical file.

          

  30. CREATE INDEXUsed to create a relational index on a specified table or view.

          

  31. Transaction log filesHOLDLOCK
    NOLOCK
    READCOMMITTED
    REPEATABLEREAD
    SERIALIZABLE

          

  32. UniqueIndicated on a result set. Means the query optimizer determined the statistic needs to be updated.

          

  33. Locks event categoryHas event classes dealing with the scanning of tables and indexes

          

  34. Multiserver, masterAn object that provides counters for monitoring internal SQL Server resource locks.

          

  35. Fill-factorUsed to specify the percentage of space on each leaf-level page for data when rebuilding or creating an index. Server-wide default value is 0.

          

  36. Primary key, automaticallyIf you create a ____, a unique clustered index on the column will be ____ created.

          

  37. ERRORFILEUsed to specify the file that is for collecting rows that have formatting errors.

          

  38. Horizontal PartitioningA database level permission that is required on all databases referenced in order to execute SHOWPLAN statements.

          

  39. NOLOCK____ is optimized for handling transactions

          

  40. REPEATABLEREADUsed to have locks placed on all data used in a query

          

  41. .xdlThe maximum size of a data file.

          

  42. HOLDLOCKUsed to use update locks instead of shared locks when you read a table, and then hold the locks until the end of the transaction.

          

  43. Advanced, max spaceDetaching a ____ will cause you to lose information about the differential bases of your differential backups.

          

  44. Hardware
    Network infrastructure
    OS configuration
    Server side applications
    Client side applications
    The ____ percentage is used only at the time of ____.

          

  45. ANSI_NULLS, QUOTED IDENTIFIERAn index build on the same partition scheme as its corresponding table.

          

  46. Estimated execution, include actualThe Management Studio GUI lets you see the Query Execution Plan by selecting either the Display ____ Plan or ____ Execution Plan.

          

  47. Media setUse to insert a defined value into the column whenever there is not value specified. Can be used with INSERT to explicitly insert a default value.

          

  48. DenormalizationBackups created on a single non-mirrored device or a set of mirrored devices within a media set.

          

  49. SET SHOWPLAN_TEXTShows information about sessions that are opened in the Advisor.

          

  50. Backup compressionA server-level configuration option that is set to off by default. Works to compress the backups.

          

  51. Events SelectionBroken down into categories, they provide different monitoring abilities in the traces.

          

  52. Maintenance PlanUsed to create Integration Services package to be run by an SQL Server Agent job. Must be in the sysadmin role to create or manage.

          

  53. SelectivityUsed to bulk copy data between an instance and a data file in a separate user-specified format.

          

  54. Session MonitorAn ordered collection of backup media, tapes or disk files

          

  55. BCP UtilityThe ratio of qualifying rows to total rows. When low the index is highly selected.

          

  56. Disable, clusteredIf you ____ a ____ view it will be disabled, and the associated nonclustered indexes with get automatically deleted until index is dropped and rebuilt.

          

  57. Media familyUse to insert a defined value into the column whenever there is not value specified. Can be used with INSERT to explicitly insert a default value.

          

  58. Trace flag 1222Takes place when SQL Server needs to scan the data to find the records.

          

  59. ROWLOCKUsed to lock data at a row level

          

  60. More, SELECTAn ordered collection of backup media, tapes or disk files

          

  61. Cannot, earlierYou may have a maximum of ____ hint from each ____ at the same time.

          

  62. Always, nonclustered indexesA non-clustered index optimized with a filter predicate to index only a portion of rows in a table.

          

  63. Aligned indexRebuilds a clustered index but does not rebuild the associated nonclustered indexes unless you use the keyword ALL.

          

  64. Text, image columns____ and ____ should be placed in a different file group on a different physical drive since they are I/O heavy.

          

  65. Pad IndexWhen enabled the percentage of free space that is specified by the fill factor is applied to the intermediate level pages of an index. It represents the same thing as fill factor for non-leaf levels.

          

  66. Third normal form (3NF)Process that involves deploying methods to separate data into multiple related tables.

          

  67. Nonaligned indexAn index which is partitioned independently from it's corresponding table.

          

  68. Errors and Warnings event categoryThe result set produced by a ____ is not stored ____.

          

  69. 116 charactersThe specified temporary table name should not exceed ____.

          

  70. Multiple-column indexUsed to evaluate filter expressions that are intended to match a prefix set of columns. Always put the most selective columns leftmost in the key.

          

  71. Primary keysServes as the default group when database is created. Should only be used to keep system objects, and not as the default file group.

          

  72. SQL Server:LatchesRecords events as they occur. Through a trace you can look at the commands that have been executed against the database.

          

  73. Backup setStatement used to make a full backup.

          

  74. Database Engine Tuning AdvisorUsed to select and create an optimal set of indexes, indexed views, and partitions.

          

  75. Full
    Simple
    Bulk-logged
    The available types of recovery models.

          

  76. PAGLOCKOption that specified that a table-level lock is used for the duration of the entire bulk-import operation.

          

  77. OLTP____ is optimized for handling transactions

          

  78. CREATE XML INDEXSecondary XML index useful for performing value-based queries when the full path is not known.

          

  79. Execution Plan statementsSET SHOWPLAN_XML ON
    SET SHOWPLAN_ALL ON
    SET SHOWPLAN_TEXT ON
    SET STATISTICS XML ON
    SET STATISTICS PROFILE ON

          

  80. MSDB, updatedAn ordered collection of backup media, tapes or disk files

          

  81. Resource database, tempdbThe ____ and the ____ cannot be backed up.

          

  82. Granularity hintsTells the total wait time for locks in the last second.

          

  83. 30%, ALTER INDEX REBUILDA value above ____ is when you should rebuild the index entirely using ____ WITH(ONLINE = ON)*.

          

  84. Data CardinalityVery limited values

          

  85. Instance, master databaseYou should have the master database backed up whenever a ____ is created, changed or dropped.

          

  86. READCOMMITTEDUsed to read only data from those already-committed transactions.

          

  87. Sessions event categoryTo create a ____ maintenance plan there must be one ____ server with one or more target servers and it must be created and maintained on the master server.

          

  88. Key-range locksOnly one transaction can obtain this to a resource at any point in time.

          

  89. Separate, indexesUsed to create a relational index on a specified table or view.

          

  90. ad hoc, views, stored proceduresSET STATISTICS PROFILE is useful for ____ queries, ____ and ____.

          

  91. Lock Wait TimeTells the average amount of wait time for each lock request.

          

  92. Exclusive, deadlockIf two or more transactions are trying to convert to ____ locks, a ____ will occur.

          

  93. 3 times, freeThe default for index ____ is ____.

          

  94. CREATE PARTITION FUNCTIONCreates a partition function and specifies the number of partitions, partition column and the range of partition column values for each partition.

          

  95. High Data CardinalityValues are very uncommon, uniqueness more likely

          

  96. FASTFIRSTROWUsed to import a data file into a table or view.

          

  97. Intent locksUsed to single an intent to place locks at lower level. They can be intent shared, intent exclusive, or shared intent exclusive.

          

  98. Recovery modelsThese determine how much data loss is considered acceptable after a failure and what types of related functions are allowed.

          

  99. Average Wait TimeTells the average amount of wait time for each lock request.

          

  100. avg_fragmentation_in_percentDescribes the percentage of logical fragmentation.

          

  101. Fill FactorThe values that represents the percentage to fill the data page files on index creation at the index leaf-layer.

          

  102. SET SHOWPLAN_ALLSQL Server will return the execution information for each statement without actually executing it.

          

  103. Seek____ is optimized for handling transactions

          

  104. dtaUses an index to pinpoint a record. Faster than scan.

          

  105. CREATE DATABASE, FOR ATTACHA workspace for holding temporary objects and result sets.

          

  106. Queryout, bcp utilityWith the ____ option ____ does not make use of T-SQL at all.

          

  107. Backup mediaA file, device or a tape used for backups.

          

  108. ALTER DATABASE, MODIFY FILEYou can adjust the file sizing by using ____ and then ____ T-SQL statements.

          

  109. Path XML indexAn index build on the same partition scheme as its corresponding table.

          

  110. OLTPOnline Transaction Processing, requires fast write, fast update

          

  111. sysadmin, db_ddladmin, db_ownerTo change the fill factor you should be a member of the ____ fixed server role, or the ____ and ____ fixed database roles.

          

  112. FILENAME SIZE MAXSIZEThe options that can be used with the CREATE DATABASE statement.

          

  113. Update locksOnly one transaction can obtain this to a resource at any point in time.

          

  114. Locks, deadlocksApplications seldom request locks directly as locks are managed by the ____.

          

  115. Tuning templateCollects information relevant for tuning SQL Server's performance.

          

  116. Import/Export WizardTool to help with importing and exporting data.

          

  117. Trace, templateGathers information of each T-SQL statement for recreating the same activity in the future.

          

  118. CREATE PARTITION SCHEMEThe uniqueness of data values contained in a column

          

  119. SET STATISTICS PROFILEWhen on, each executed query will return a regular result set and then an additional result set that details the profile of the query execution.

          

  120. Schema modification locksOnly one transaction can obtain this to a resource at any point in time.

          

  121. Master DatabaseThe ____ is for recording system-level information for an instance.

          

  122. SET STATISTICS XMLUsed to allow SQL Server to execute the T-SQL statements while generating in-depth information on how the statements were executed.

          

  123. LockingUsed to use an exclusive lock on all the involved resources until the transaction is ended.

          

  124. Contained DatabaseThe ____ is for recording system-level information for an instance.

          

  125. Standard view, permanentlyThe result set produced by a ____ is not stored ____.

          

  126. OLAPOnline Analytical Processing, requires fast read and computation on the fly.

          

  127. Table-level locking hintsHOLDLOCK
    NOLOCK
    READCOMMITTED
    REPEATABLEREAD
    SERIALIZABLE

          

  128. Cannot, stored proceduresThe SET SHOWPLAN statements ____ be used inside a ____ since they must be the only statement in a batch.

          

  129. Activity monitor____ means breaking a table into multiple smaller ones

          

  130. Primary file, model databaseWhen size is not supplied, the size of the ____ will be set to the size of the file in the ____.

          

  131. MSDB databaseUsed by the SQL Server Agent to schedule alerts and jobs.

          

  132. Local temporary tablesMaintained only in the current session and it's name should always be prefixed with a #. Dropped automatically at the end of the current session.

          

  133. 16 TBUsed to lock data at a row level

          

  134. DML Triggers, defaultsWhen you have ____ indexes, ____ queries will run faster, but INSERT, UPDATE, and DELETE will run slower.

          

  135. Tables and Indexes____ should be in separate file groups.

          

  136. NormalizingProcess that involves deploying methods to separate data into multiple related tables.

          

  137. Property XML indexUsed to create a relational index on a specified table or view.

          

  138. Bulk-logged modelRecovery model that requires log backups. Permits high-performance bulk copy operations. It is not possible to restore to a specific point in time.

          

  139. SET OFFLINE, SET ONLINE____ and ____ options of ALTER DATABASE allows you to take the instance offline or bring it back online.

          

  140. Security Audit event categoryHas event classes useful for auditing server activity.

          

  141. sp_detach_dbUsed to detach a database currently not in use from an instance.

          

  142. INCLUDE argumentUse to insert a defined value into the column whenever there is not value specified. Can be used with INSERT to explicitly insert a default value.

          

  143. Foreign key, self-referencingCHECK constraints work at the ____ to ____values that evaluate to FALSE.

          

  144. Differential, modifiedThe ____ backup is useful when a subset of data is ____ more often then the rest of the database.

          

  145. DATAFILETYPEUsed to bulk copy data between an instance and a data file in a separate user-specified format.

          

  146. offline, shared lock, exclusive tableA ____ can only be a member of a ____.

          

  147. AUTO_UPDATE_STATISTICS_ASYNC, OFFUsed to evaluate the selectivity of an index. Shows the current distribution statistic for a particular table and index, or for all tables and indexes.

          

  148. Event ClassesUsed to single an intent to place locks at lower level. They can be intent shared, intent exclusive, or shared intent exclusive.

          

  149. Active User TasksDatabase mode that allows for only a single user to be connected. All other users will be cut off without warning when set.

          

  150. Fourth normal form (4NF)____ requires that all multi-valued dependencies be removed.

          

  151. BULK INSERTUsed to import a data file into a table or view.

          

  152. Lock managerApplications seldom request locks directly as locks are managed by the ____.

          

  153. sysadmin fixed, db_ownerThe ____ server role is required to initialize it. After the initialization users who are members of the ____ fixed role can use it to tune the databases they own.

          

  154. Exclusive lockUsed to use an exclusive lock on all the involved resources until the transaction is ended.

          

  155. Limit, heavyAn ordered collection of backup media, tapes or disk files

          

  156. Low Data CardinalityVery limited values

          

  157. Number of Deadlocks/secEvent class that populates the TextData data column of the trace with data on process and objects involved in the deadlock.

          

  158. Single User ModeAn index which is partitioned independently from it's corresponding table.

          

  159. Page splitThe process of making room for new records.

          

  160. Character format, third party programYou should use ____ when bulk exporting data to a text file, or bulk importing data from a text file generated by a ____.

          

  161. 999 nonclusteredA table can have a maximum of ____ indexes.

          

  162. Data File I/OUse to insert a defined value into the column whenever there is not value specified. Can be used with INSERT to explicitly insert a default value.

          

  163. Second normal form (2NF)____ requires that you remove all those columns that are not dependent on the primary key.

          

  164. Primary file groupUsed to specify the file that is for collecting rows that have formatting errors.

          

  165. Workload analysis____ can be performed against the master, model, msdb, ReportServer, ReportServerTempDB, and tempdb databases.

          

  166. Isolation-Level hints____ can never join any filegroup.

          

  167. SQL Server:LocksAllows concurrent transactions to SELECT a resource under pessimistic concurrency control. During an update a transaction will attempt to change to an exclusive lock.

          

  168. Indexed, infrequently____ view is good for views with data that is ____ updated (read intensive).

          

  169. ALTER INDEX, REBUILDA ____ that has a unique clustered index is an ____.

          

  170. Full modelRecovery model that requires log backups and there will be no data loss. Possible to restore to a specific point in time.

          

  171. SET SHOWPLAN ONSQL Server will return the execution information for each statement without actually executing it.

          

  172. Large object, cannot____ date types such as ntext, varchar(max), xml and image ____ be used as the key columns for an index.

          

  173. Catalog viewsDesigned for returning information used by the SQL Server Database Engine.

          

  174. Value XML indexSecondary XML index useful for performing value-based queries when the full path is not known.

          

  175. tempdb databaseA workspace for holding temporary objects and result sets.

          

  176. 30%, ALTER INDEX REORGANIZEA value between 5% and ____ is when you should use ____ to reorganize the index

          

  177. Row level, rejectUsed to lock data at a row level

          

  178. ALTER DATABASE statement optionsADD FILE
    ... TO FILEGROUP
    REMOVE FILE
    MODIFY FILE
    ADD FILEGROUP
    REMOVE FILEGROUP
    MODIFY FILEGROUP

          

  179. First normal form (1NF)____ require that you eliminate duplicative columns from the same table and create separate tables for each group of related data, and identify a primary key

          

  180. Tail-log backupSpecial backup that captures the log records that have not been backed up in other ways. Is needed to recover SQL Server to the latest point in time.

          

  181. ALTER DATABASE database_name MODIFY FILE
    Stop the instance
    Move the file
    Restart the instance
    When all the files in a filegroup are full, the ____ will automatically ____ at a time.

          

  182. CLUSTERED indexAn index that has a logical order of key values which determines the physical order of the corresponding rows. Each table or view can have only one.

          

  183. Default, 1023Used to have those rows locked by other processes skipped.

          

  184. UNIQUE argumentWhen you have ____ indexes, ____ queries will run faster, but INSERT, UPDATE, and DELETE will run slower.

          

  185. Conceptual Database DesignThe template for all databases created on the instance.

          

  186. Contained database users, Windows usersContained databases can be accessed by ____ with passwords authenticated by the database, and authorized ____ and Windows groups who connect directly to the database without logins in the master database.

          

  187. sys.dm_db_index_physical_statsDuring upgrades the Database Engine will automatically disable an index, but to use T-SQL statements you would use ____ with the ____ option.

          

  188. Recent Expensive QueriesUsed to single an intent to place locks at lower level. They can be intent shared, intent exclusive, or shared intent exclusive.

          

  189. READPASTUsed to have those rows locked by other processes skipped.

          

  190. Physical DesignIndicated on a result set. Means the query optimizer determined the statistic needs to be updated.

          

  191. SERIALIZABLESame as HOLDLOCK: Used to hold a shared lock until the transaction is completed.

          

  192. TSQL event categoryHas event classes produced by executing T-SQL statements in an instance.

          

  193. STALE____ is optimized for adhoc result aggregation and summarization of large amounts of data.

          

  194. System, never____ databases can ____ be attached.

          

  195. NONCLUSTERED indexAn index where the physical order of the rows is totally independent of their indexed order. Can be unique or non-unique.

          

  196. sp_spaceused____ should be backed up whenever it is ____.

          

  197. Maintenance Plan TasksBack up Database
    Check Database Integrity
    Execute SQL Server Agent Job
    Execute T-SQL Statement
    History Cleanup
    Maintenance Cleanup
    Notify Operator
    Rebuild Index
    Reorganize Index
    Shrink Database
    Update Statistics

          

  198. DBCC DBREINDEXRebuilds a clustered index but does not rebuild the associated nonclustered indexes unless you use the keyword ALL.

          

  199. Granularity and Isolation-LevelUsed to configure the isolation level

          

  200. SHOWPLAN SQL Server Profiler event classesShowplan XML
    Showplan ALL
    Showplan Text
    Showplan XML Statistics Profile
    Showplan Statistics Profile

          

  201. Data, Transaction logThe uniqueness of data values contained in a column

          

  202. First index, uniqueUse to not allow two rows in a table to have the same value for the columns.

          

  203. CheckUsed to enforce domain integrity. Use when you want to limit the values that can be entered into a column.

          

  204. 2 TBThe maximum size of a log file.

          

  205. Resource databaseUse for holding system objects that are included with SQL Server and is read only.

          

  206. Average Latch Wait Time (MS)Tells the average latch wait time for latch requests that had to wait.

          

  207. Only base, same databaseThe view must reference ____ tables in the ____ as the view.

          

  208. Create a new filegroup
    Mark as Default
    Create new data file (.ndf)
    To use a secondary data file you need to ____, ____, and then ____.

          

  209. PartitioningThe process of making room for new records.

          

  210. UNLIMITEDUse to not allow two rows in a table to have the same value for the columns.

          

  211. 1000 partitionsYou can have a maximum of ____ per table.

          

  212. BACKUPStatement used to make a full backup.

          

  213. Frequently, unique clusteredIf a view is ____ referenced, you should create a ____ index on the view so the result can be stored like a table.

          

  214. SET TRANSACTION ISOLATION LEVELUsed to configure the isolation level

          

  215. SHOWPLAN permissionShows information about sessions that are opened in the Advisor.

          

  216. Data type, partitions, boundaryHow SQL Server attempts to determine the best way to execute a submitted query.

          

  217. Logical Database DesignDesign that requires the construction of a model of information that can be mapped into the various SQL Server objects.

          

  218. Latch Waits/secTell the number of latch request that were not granted immediately.

          

  219. SQL Server ProfilerAn object that provides information about SQL Server locks on resources that prevent concurrent use by different transactions.

          

  220. XML, should, CREATE PRIMARY XML INDEXUsed to evaluate filter expressions that are intended to match a prefix set of columns. Always put the most selective columns leftmost in the key.

          

  221. Foreign keysUsed to create a relational index on a specified table or view.

          

  222. Secondary data file, log fileUsed when compiling and executing queries.

          

  223. Shared locksAllows concurrent transactions to SELECT a resource under pessimistic concurrency control. During an update a transaction will attempt to change to an exclusive lock.

          

  224. SQL Server lock levelsRows
    Pages (collection of rows)
    Extents (collection of pages)
    Table
    Database

          

  225. Primary, automaticallyWhen you have ____ and Foreign key constraints SQL Server will ____ create indexes for them.

          

  226. READ COMMITTEDUsed to specify the file that is for collecting rows that have formatting errors.

          

  227. ERD stands forEntity Relationship Diagram

          

  228. Host one file per disk.When using physical disk drives you should create multiple physical files per file group and ____ if possible.

          

  229. Workload____ is optimized for adhoc result aggregation and summarization of large amounts of data.

          

  230. Standard templateCollects general information on SQL Server connections, stored procedures and T-SQL Statements.

          

  231. Stored Procedures event categoryHas event classes used to monitor locking activity in an instance

          

  232. Resource WaitsProvides the wait state information

          

  233. Filtered IndexSecondary XML index useful for performing value-based queries when the full path is not known.

          

  234. Display Estimated, SHOWPLAN_XMLThe ____ execution plan is the same as using the SET ____ statement.

          

  235. Full, differentialAn object that provides information about SQL Server locks on resources that prevent concurrent use by different transactions.

          

  236. sp_show_statisticsUsed to allow SQL Server to execute the T-SQL statements while generating in-depth information on how the statements were executed.

          

  237. ALTER INDEX, DISABLEA value above ____ is when you should rebuild the index entirely using ____ WITH(ONLINE = ON)*.

          

  238. DefaultIndicated on a result set. Means the query optimizer determined the statistic needs to be updated.

          

  239. TABLOCKOption that specified that a table-level lock is used for the duration of the entire bulk-import operation.

          

  240. reduce, rebuildingDeveloping a visual representation of the real world problem as an ERD and have the details modeled in terms of entities, attributes and relations.

          

  241. Complete database restoreUsed by the SQL Server Agent to schedule alerts and jobs.

          

  242. Performance event categoryHas event classes produced when DML operators are running.

          

  243. Do not, schema, formatEntity Relationship Diagram

          

  244. Lock Timeouts/secIf no value is specified, the Advisor will assume a space limit of ____ the current raw data size, OR the ____ space on all the attached drives in addition to raw data size.

          

  245. Size, Object ExplorerYou can adjust the ____ of the database via ____.

          

  246. OLAPThe maximum size of a log file.

          

  247. Partially Contained DatabaseThe ____ is for recording system-level information for an instance.

          

  248. 32,767Used to enforce domain integrity. Use when you want to limit the values that can be entered into a column.

          

  249. Trace flag 1204Use to insert a defined value into the column whenever there is not value specified. Can be used with INSERT to explicitly insert a default value.

          

  250. Read-only databaseDetaching a ____ will cause you to lose information about the differential bases of your differential backups.

          

  251. Schema stability locksNo other transactions can change data and read operations can carry on only with the presence of a NOLOCK hint or read uncommitted isolation level.

          

  252. Query Execution PlanHow SQL Server attempts to determine the best way to execute a submitted query.

          

  253. Differential backupUsed to specify the percentage of space on each leaf-level page for data when rebuilding or creating an index. Server-wide default value is 0.

          

  254. ER ModelingDeveloping a visual representation of the real world problem as an ERD and have the details modeled in terms of entities, attributes and relations.

          

  255. Total Latch Wait Time (ms)Tells the total latch wait time for latch requests in the last second.

          

  256. View, indexed viewUsed to create a relational index on a specified table or view.

          

  257. ALTER DATABASE, SET SINGLE_USERSet single user with T-SQL using ____ and then ____.

          

  258. Deadlock graphA value that can be char, native, widechar, widenative

          

  259. Padding, OFFThe default for index ____ is ____.

          

  260. Scans event categoryHas event classes produced when DML operators are running.

          

  261. Table scanTakes place when SQL Server needs to scan the data to find the records.

          

  262. aggregations, writeTells the average amount of wait time for each lock request.

          

  263. Fill factor, index creationThe ____ percentage is used only at the time of ____.

          

  264. Stored procedure, optimizedPut the queries in a _____ and SQL Server can usually come up with an ____ execution plan.

          

  265. Vertical PartitioningYou can ____ index fragmentation through ____ or reorganizing an index.

          

  266. Include Actual, SET STATISTICSThe ____ execution plan is the same as using the ____ XML.

          

  267. Database event categoryHas event classes used to monitor locking activity in an instance

          

  268. Database Engine Tuning Adivisor DTAToll that can examine how queries are processed and then recommend how you may improve the query processing performance.

          

  269. Logs, another disk____ should be on ____.

          

  270. READ_COMMITED_SNAPSHOTIf OFF, shared locks will be used to prevent other transactions from modifying rows while the current transaction is reading, and block the statement from reading row modified until completed. If ON, row versioning will be used to present each statement with a consistent snapshot of the data.