NAME

Question types


Start with


Question limit

of 270 available terms

Print test

268 Matching questions

  1. SET SHOWPLAN ON
  2. Model database
  3. Locks, deadlocks
  4. Tuning template
  5. BCP Utility
  6. One, group
  7. ALTER INDEX, DISABLE
  8. Table scan
  9. Path XML index
  10. .xdl
  11. CREATE PARTITION FUNCTION
  12. Errors and Warnings event category
  13. Check
  14. BULK INSERT
  15. Display Estimated, SHOWPLAN_XML
  16. reduce, rebuilding
  17. TABLOCK
  18. OLTP
  19. Indexed, infrequently
  20. SHOWPLAN permission
  21. Workload
  22. Import/Export Wizard
  23. STALE
  24. Default, 1023
  25. CREATE INDEX
  26. 32,767
  27. Bulk update locks
  28. Selectivity
  29. offline, shared lock, exclusive table
  30. Constraints
  31. Local temporary tables
  32. SQL Server's Filegroups
  33. SQL Server:Locks
  34. Contained Database
  35. Cannot, uncompressed, media set
  36. Logs, another disk
  37. Horizontal Partitioning
  38. Recovery models
  39. Granularity and Isolation-Level
  40. Resource database
  41. UNLIMITED
  42. Global temporary tables
  43. Exclusive lock
  44. avg_fragmentation_in_percent
  45. 1000 partitions
  46. ROWLOCK
  47. Character format, third party program
  48. Secondary data file, log file
  49. Only base, same database
  50. Maintenance Plan Tasks
  51. 999 nonclustered
  52. Media set
  53. Vertical Partitioning
  54. Media family
  55. Catalog views
  56. Database Engine Tuning Advisor
  57. READ_COMMITED_SNAPSHOT
  58. stored procedure, DROP TABLE
  59. CREATE XML INDEX
  60. Granularity hints
  61. Events Selection
  62. SQL Server lock levels
  63. Separate, indexes
  64. 16 TB
  65. Performance event category
  66. Sessions event category
  67. SQL Server Profiler
  68. Update locks
  69. SET SHOWPLAN_TEXT
  70. Locks event category
  71. Nonaligned index
  72. Database Engine Tuning Adivisor DTA
  73. SET SHOWPLAN_ALL
  74. sysadmin fixed, db_owner
  75. Seek
  76. PAGLOCK
  77. TSQL event category
  78. Filtered Index
  79. Standard template
  80. Resource database, tempdb
  81. Third normal form (3NF)
  82. Scans event category
  83. Normal Data Cardinality
  84. May not, BACKUP
  85. FILENAME SIZE MAXSIZE
  86. Create a new filegroup
    Mark as Default
    Create new data file (.ndf)
  87. ALTER DATABASE statement options
  88. sysadmin, db_ddladmin, db_owner
  89. Lock Timeouts/sec
  90. Primary keys
  91. FASTFIRSTROW
  92. Primary, automatically
  93. aggregations, write
  94. Contained database users, Windows users
  95. Trace flag 1222
  96. Estimated execution, include actual
  97. full, model database
  98. tempdb database
  99. Backup set
  100. Latch Waits/sec
  101. Cannot, earlier
  102. 30%, ALTER INDEX REBUILD
  103. Differential backup
  104. SET TRANSACTION ISOLATION LEVEL
  105. Data, Transaction log
  106. Lock manager
  107. Intent locks
  108. Resource Waits
  109. DBCC DBREINDEX
  110. Conceptual Database Design
  111. Standard view, permanently
  112. Primary file group
  113. Primary key, automatically
  114. Stored Procedures event category
  115. Stored procedure, optimized
  116. ALTER INDEX, REBUILD
  117. ALTER DATABASE, SET SINGLE_USER
  118. Recent Expensive Queries
  119. sp_detach_db
  120. Single User Mode
  121. File, single filegroup
  122. Full
    Simple
    Bulk-logged
  123. Complete database restore
  124. Second normal form (2NF)
  125. Frequently, unique clustered
  126. Multiple-column index
  127. Locking
  128. Shared locks
  129. MSDB database
  130. First index, unique
  131. Database event category
  132. Maintenance Plan
  133. Host one file per disk.
  134. Pad Index
  135. Number of Deadlocks/sec
  136. 3 times, free
  137. Bulk-logged model
  138. Simple model
  139. Query Execution Plan
  140. Lock Timeouts
  141. Deadlock graph
  142. SET STATISTICS PROFILE
  143. SERIALIZABLE
  144. MSDB, updated
  145. XLOCK
  146. Denormalization
  147. Physical Design
  148. First normal form (1NF)
  149. Row level, reject
  150. 30%, ALTER INDEX REORGANIZE
  151. sys.backup_devices
    sys.database_files
    sys.database_mirroring
    sys.database_recovery_status
    sys.databases
    sys.master_files
  152. Disable, clustered
  153. XML, should, CREATE PRIMARY XML INDEX
  154. Fourth normal form (4NF)
  155. Session Monitor
  156. Schema stability locks
  157. 2012, partially
  158. ANSI_NULLS, QUOTED IDENTIFIER
  159. Do not, schema, format
  160. Event Classes
  161. Fill Factor
  162. ERRORFILE
  163. NOT NULL
  164. Partitioning
  165. Differential, modified
  166. SET OFFLINE, SET ONLINE
  167. Security Audit event category
  168. Data File I/O
  169. SET STATISTICS XML
  170. CREATE PARTITION SCHEME
  171. TSQL_Replay template
  172. sp_show_statistics
  173. Default
  174. Fill factor, index creation
  175. BACKUP
  176. OLAP
  177. Char, default
  178. View, indexed view
  179. Full, differential
  180. NOLOCK
  181. READ COMMITTED
  182. Property XML index
  183. Trace, template
  184. UNIQUE argument
  185. User database
  186. Page split
  187. Active User Tasks
  188. Total Latch Wait Time (ms)
  189. HOLDLOCK
  190. Include Actual, SET STATISTICS
  191. dta
  192. Always, nonclustered indexes
  193. Logical Database Design
  194. CLUSTERED index
  195. Unique Index
  196. System, never
  197. Transaction log files
  198. Foreign key, self-referencing
  199. Lock Wait Time
  200. Fragmentation
  201. 116 characters
  202. Index scan
  203. 2 TB
  204. UPDLOCK
  205. Average Latch Wait Time (MS)
  206. Backup compression
  207. Tail-log backup
  208. Fill-factor
  209. Queryout, bcp utility
  210. REPEATABLEREAD
  211. Multiserver, master
  212. Profiler, deadlock events
  213. Read-only database
  214. Full model
  215. Schema modification locks
  216. Foreign keys
  217. ALTER DATABASE database_name MODIFY FILE
    Stop the instance
    Move the file
    Restart the instance
  218. Trace flag 1204
  219. CREATE DATABASE, FOR ATTACH
  220. Cannot, stored procedures
  221. READCOMMITTED
  222. ERD stands for
  223. Primary file, model database
  224. Exclusive, deadlock
  225. Partially Contained Database
  226. AUTO_UPDATE_STATISTICS_ASYNC, OFF
  227. ad hoc, views, stored procedures
  228. NONCLUSTERED index
  229. Workload analysis
  230. File or filegroup, database
  231. ALTER DATABASE, MODIFY FILE
  232. INCLUDE argument
  233. Backup media
  234. Activity monitor
  235. Average Wait Time
  236. SQL Server:Latches
  237. Master Database
  238. Hardware
    Network infrastructure
    OS configuration
    Server side applications
    Client side applications
  239. READUNCOMMITTED
  240. Low Data Cardinality
  241. Unique
  242. Advanced, max space
  243. Data Cardinality
  244. Isolation-Level hints
  245. Table-level locking hints
  246. High Data Cardinality
  247. DATAFILETYPE
  248. Tables and Indexes
  249. More, SELECT
  250. sp_spaceused
  251. Large object, cannot
  252. Database Engine, expand one file
  253. Aligned index
  254. Text, image columns
  255. Limit, heavy
  256. READPAST
  257. Execution Plan statements
  258. Instance, master database
  259. DML Triggers, defaults
  260. Value XML index
  261. Key-range locks
  262. Normalizing
  263. sys.dm_db_index_physical_stats
  264. ER Modeling
  265. Padding, OFF
  266. SHOWPLAN SQL Server Profiler event classes
  267. Size, Object Explorer
  268. Data type, partitions, boundary
  1. a The default for index ____ is ____.
  2. b Used to have those rows locked by other processes skipped.
  3. c ____ and ____ files can be detached and attached to another instance. This makes a database easier to move.
  4. d ____ requires that all multi-valued dependencies be removed.
  5. e An index build on the same partition scheme as its corresponding table.
  6. f Values are very uncommon, uniqueness more likely
  7. g Recovery model that does not have log backups. Log space is reclaimed to keep requirements small. Can only recover to the end of a backup.
  8. h A value between 5% and ____ is when you should use ____ to reorganize the index
  9. i Uses an index to pinpoint a record. Faster than scan.
  10. j Used to use an exclusive lock on all the involved resources until the transaction is ended.
  11. k Means it will be a unique index. Cannot be created on columns with duplicate values.
  12. l Shows deadlock information by processes and then by resources.
  13. m Used to create a relational index on a specified table or view.
  14. n A mechanism that synchronizes access by users to the same data at the same time.
  15. o Collects information relevant for tuning SQL Server's performance.
  16. p Tab in Profiler to review the events to be monitored with your trace.
  17. q Since DBCC DBREINDEX is an ____ operation, when a nonclustered index is being rebuilt a ____ will be held on the table preventing modifications. When a clustered index is being rebuilt an ____ lock will be held, preventing table access entirely.
  18. r Back 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
  19. s A constraint linked to a primary key in another table. Can also use columns that use UNIQUE.
  20. t If you ____ a ____ view it will be disabled, and the associated nonclustered indexes with get automatically deleted until index is dropped and rebuilt.
  21. u Maintained only in the current session and it's name should always be prefixed with a #. Dropped automatically at the end of the current session.
  22. v A ____ file group should be created for ____.
  23. w ____ means breaking a table into multiple smaller ones
  24. x ____ requires data redundancy by can reduce the number of joins to be use during query
  25. y Has event classes useful for auditing server activity.
  26. z Creates a secondary XML index.
  27. aa With the ____ option ____ does not make use of T-SQL at all.
  28. ab Use ____ with the ____ option to have an index rebuild using the same columns, index type, uniqueness attribute and sort order.
  29. ac Tells the total latch wait time for latch requests in the last second.
  30. ad Creates a partition scheme and maps the partitions to a set of filegroups.
  31. ae Design that requires the construction of a model of information that can be mapped into the various SQL Server objects.
  32. af System function used to detect index fragmentation.
  33. ag The arguments of the partition function must have the same ____, define the same number of ____ and use the same ____ values.
  34. ah The ratio of qualifying rows to total rows. When low the index is highly selected.
  35. ai Shows information about sessions that are opened in the Advisor.
  36. aj Queries that have few ____ or joins would not be suitable for indexed view, and ____ intensive transactions would not be appropriate.
  37. ak A non-clustered index optimized with a filter predicate to index only a portion of rows in a table.
  38. al Used to lock data at a row level
  39. am Use to not allow two rows in a table to have the same value for the columns.
  40. an ____ should be in separate file groups.
  41. ao ____ requires that you remove all subsets of data that apply to multiple rows of a table and relocate them in other separate tables, and create foreign keys
  42. ap PAGLOCK
    NOLOCK
    ROWLOCK
    TABLOCK
  43. aq A database level permission that is required on all databases referenced in order to execute SHOWPLAN statements.
  44. ar The available types of recovery models.
  45. as You should have the master database backed up whenever a ____ is created, changed or dropped.
  46. at ____ are factors that can affect SQL Server performance.
  47. au HOLDLOCK
    NOLOCK
    READCOMMITTED
    REPEATABLEREAD
    SERIALIZABLE
  48. av Partition the table by group rows based on a particular criteria
  49. aw Used to detach a database currently not in use from an instance.
  50. ax A value above ____ is when you should rebuild the index entirely using ____ WITH(ONLINE = ON)*.
  51. ay Used to evaluate filter expressions that are intended to match a prefix set of columns. Always put the most selective columns leftmost in the key.
  52. az The whole database is made offline for the duration and all data is recovered to a point where no uncommitted transactions exist.
  53. ba Set single user with T-SQL using ____ and then ____.
  54. bb You can adjust the file sizing by using ____ and then ____ T-SQL statements.
  55. bc Event class that populates the TextData data column of the trace with data on process and objects involved in the deadlock.
  56. bd A ____ can only be a member of a ____.
  57. be ____ should be backed up whenever it is ____.
  58. bf The result set produced by a ____ is not stored ____.
  59. bg Detaching a ____ will cause you to lose information about the differential bases of your differential backups.
  60. bh Displays information for those active user connections made to the server
  61. bi You can adjust the ____ of the database via ____.
  62. bj When using physical disk drives you should create multiple physical files per file group and ____ if possible.
  63. bk Used to select and create an optimal set of indexes, indexed views, and partitions.
  64. bl Used for preventing phantom reads.
  65. bm Has event classes produced when a SQL Server error or warning is raised.
  66. bn Backups created on a single non-mirrored device or a set of mirrored devices within a media set.
  67. bo To change the fill factor you should be a member of the ____ fixed server role, or the ____ and ____ fixed database roles.
  68. bp Applications seldom request locks directly as locks are managed by the ____.
  69. bq When you have ____ indexes, ____ queries will run faster, but INSERT, UPDATE, and DELETE will run slower.
  70. br In the ____ options box you can define the ____ for recommendations or by the physical design structures.
  71. bs SET SHOWPLAN_XML ON
    SET SHOWPLAN_ALL ON
    SET SHOWPLAN_TEXT ON
    SET STATISTICS XML ON
    SET STATISTICS PROFILE ON
  72. bt Describes the percentage of logical fragmentation.
  73. bu ____ 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
  74. bv When size is not supplied for the ____ or ____ the default will be 1 MB.
  75. bw Used to use update locks instead of shared locks when you read a table, and then hold the locks until the end of the transaction.
  76. bx Provides the wait state information
  77. by Used to lock the table.
  78. bz Rows
    Pages (collection of rows)
    Extents (collection of pages)
    Table
    Database
  79. ca Has event classes produced when data or log files grow or shrink.
  80. cb Allows concurrent transactions to SELECT a resource under pessimistic concurrency control. During an update a transaction will attempt to change to an exclusive lock.
  81. cc Used by the SQL Server Agent to schedule alerts and jobs.
  82. cd The views related to databases and files are ____.
  83. ce Designed for returning information used by the SQL Server Database Engine.
  84. cf Captures the data that has changed since the last full backup.
  85. cg The options that can be used with the CREATE DATABASE statement.
  86. ch Same as NOLOCK: Used to NOT issue any shared locks or recognize exclusive locks.
  87. ci The template for all databases created on the instance.
  88. cj Toll that can examine how queries are processed and then recommend how you may improve the query processing performance.
  89. ck The maximum size of a log file.
  90. cl To restore, the ____ must be running and the ____ must be accessible and partly or full usable.
  91. cm Tool to help with importing and exporting data.
  92. cn Used to have locks placed on all data used in a query
  93. co During upgrades the Database Engine will automatically disable an index, but to use T-SQL statements you would use ____ with the ____ option.
  94. cp Contained 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.
  95. cq Secondary XML index useful for when the path to the value is known.
  96. cr Overrides SQL Server's locking scheme by forcing locks on a table.
    FASTFIRSTROW
    HOLDLOCK
    NOLOCK
    PAGLOCK
    READCOMMITTED
    READPAST
    READUNCOMMITTED
    REPEATABLEREAD
    ROWLOCK
    SERIALIZABLE
    TABLOCK
    UPDLOCK
    XLOCK
  97. cs A table can have a maximum of ____ indexes.
  98. ct Used to read only data from those already-committed transactions.
  99. cu Statement used to make a full backup.
  100. cv Records events as they occur. Through a trace you can look at the commands that have been executed against the database.
  101. cw Broken down into categories, they provide different monitoring abilities in the traces.
  102. cx ____ is optimized for adhoc result aggregation and summarization of large amounts of data.
  103. cy ADD FILE
    ... TO FILEGROUP
    REMOVE FILE
    MODIFY FILE
    ADD FILEGROUP
    REMOVE FILEGROUP
    MODIFY FILEGROUP
  104. cz Backups created by recent version of SQL Server ____ be restored to an ____ version.
  105. da Create only ____ database backups of the ____ as required since it rarely changes.
  106. db Used when you are bulk copying data into a table while the TABLOCK hint is there.
  107. dc Maintained across all the active sessions and it's name should always be prefixed with ##. Dropped automatically when session that created the table is ended.
  108. dd Used to enforce uniqueness but they do not allow for NULL
  109. de To attach a database make sure all MDF and NDF files are available and use the ____ with the ____ close.
  110. df Reveals /O information for the database data and log files
  111. dg According to MS using constraints is perfered over ____, rules and ____.
  112. dh Used to allow SQL Server to execute the T-SQL statements while generating in-depth information on how the statements were executed.
  113. di A workspace for holding temporary objects and result sets.
  114. dj The ____ execution plan is the same as using the ____ XML.
  115. dk Tells the average latch wait time for latch requests that had to wait.
  116. dl Database mode that allows for only a single user to be connected. All other users will be cut off without warning when set.
  117. dm Has event classes produced by executing T-SQL statements in an instance.
  118. dn An index which is partitioned independently from it's corresponding table.
  119. do It's behavior depends on the value of READ_COMMITTED_SNAPSHOT.
  120. dp If two or more transactions are trying to convert to ____ locks, a ____ will occur.
  121. dq If a view is ____ referenced, you should create a ____ index on the view so the result can be stored like a table.
  122. dr ____ databases can ____ be attached.
  123. ds SQL Server ____'s contained database feature only supports a ____ contained state.
  124. dt Tells the total wait time for locks in the last second.
  125. du Serves as the default group when database is created. Should only be used to keep system objects, and not as the default file group.
  126. dv Has event classes dealing with the scanning of tables and indexes
  127. dw You can use SQL Server ____ to identify the cause by tracing ____.
  128. dx Very limited values
  129. dy These determine how much data loss is considered acceptable after a failure and what types of related functions are allowed.
  130. dz Special 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.
  131. ea To 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.
  132. eb Used to create Integration Services package to be run by an SQL Server Agent job. Must be in the sysadmin role to create or manage.
  133. ec Has event classes used to monitor locking activity in an instance
  134. ed Exists when your indexes have pages in which the logical ordering does not match the physical ordering inside the physical file.
  135. ee You can ____ index fragmentation through ____ or reorganizing an index.
  136. ef You should ____ tuning time to stop during periods of ____ server workload.
  137. eg ____ view is good for views with data that is ____ updated (read intensive).
  138. eh An object that provides counters for monitoring internal SQL Server resource locks.
  139. ei A ____ that has a unique clustered index is an ____.
  140. ej Means the file can grown until the disk is full (or reaches it's maximum size)
  141. ek You should use ____ when bulk exporting data to a text file, or bulk importing data from a text file generated by a ____.
  142. el Constructing a data model for dealing with a real world issue without giving any physical considerations.
  143. em Put the queries in a _____ and SQL Server can usually come up with an ____ execution plan.
  144. en The deadlock XML file extension
  145. eo Used to configure the isolation level
  146. ep Has event classes produced when clients connect to and disconnect from an instance
  147. eq Showplan XML
    Showplan ALL
    Showplan Text
    Showplan XML Statistics Profile
    Showplan Statistics Profile
  148. er Used to define how the integrity of your database can be enforced automatically.
  149. es A database that allows some but not all features that cross the database boundary.
  150. et An index where the physical order of the rows is totally independent of their indexed order. Can be unique or non-unique.
  151. eu A ____ can be used only by a single ____.
  152. ev Process that involves deploying methods to separate data into multiple related tables.
  153. ew ____ monitors activities in real time.
  154. ex Option that specified that a table-level lock is used for the duration of the entire bulk-import operation.
  155. ey The ____ is for recording system-level information for an instance.
  156. ez ____ should be on ____.
  157. fa Shows deadlock information formatted by each node involved.
  158. fb Used to specify that a column does not take NULL values (which are unknown or undefined).
  159. fc Used during DDL operation.
  160. fd SQL Server will return the execution information for each statement without actually executing it.
  161. fe The values that represents the percentage to fill the data page files on index creation at the index leaf-layer.
  162. ff A server-level configuration option that is set to off by default. Works to compress the backups.
  163. fg When you have ____ and Foreign key constraints SQL Server will ____ create indexes for them.
  164. fh Use 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.
  165. fi If 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.
  166. fj You should ____ create a clustered index prior to creating any ____.
  167. fk You can base a ____ on a ____.
  168. fl The categories for hints.
  169. fm Used to enforce domain integrity. Use when you want to limit the values that can be entered into a column.
  170. fn Use for holding system objects that are included with SQL Server and is read only.
  171. fo ____ can be performed against the master, model, msdb, ReportServer, ReportServerTempDB, and tempdb databases.
  172. fp The SET SHOWPLAN statements ____ be used inside a ____ since they must be the only statement in a batch.
  173. fq ____ and ____ options of ALTER DATABASE allows you to take the instance offline or bring it back online.
  174. fr Only one transaction can obtain this to a resource at any point in time.
  175. fs Tells the average amount of wait time for each lock request.
  176. ft To create an indexed view ____ and ____ options must be ON when you run CREATE VIEW using WITH SCHEMABINDING.
  177. fu Takes place when SQL Server needs to scan the data to find the records.
  178. fv You may have a maximum of ____ hint from each ____ at the same time.
  179. fw BCP data files ____ include any ____ or ____ information.
  180. fx Has the backup contents added to the media set by backup process.
  181. fy ____, worker threads, memory, parallel query execution-related resources and Multiple Active Results Sets resources can all cause ____.
  182. fz Used to NOT issue any shared locks or recognize exclusive locks. Use only with the SELECT statement.
  183. ga How SQL Server attempts to determine the best way to execute a submitted query.
  184. gb The ____ percentage is used only at the time of ____.
  185. gc The ____ backup is useful when a subset of data is ____ more often then the rest of the database.
  186. gd To use a secondary data file you need to ____, ____, and then ____.
  187. ge ____ requires that you remove all those columns that are not dependent on the primary key.
  188. gf The ____ execution plan is the same as using the SET ____ statement.
  189. gg The process of producing a detailed database specific data model to meet end user requirements.
  190. gh If 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.
  191. gi An 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.
  192. gj When 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.
  193. gk When a ____ constraint references columns in tables in the same database or table, the table becomes a ____ table.
  194. gl When size is not supplied, the size of the ____ will be set to the size of the file in the ____.
  195. gm Identified the most expensive queries
  196. gn Takes place when SQL Server needs to scan the index pages to find the records
  197. go ____ is optimized for handling transactions
  198. gp Used to bulk copy data between an instance and a data file in a separate user-specified format.
  199. gq Tell the number of latch request that were not granted immediately.
  200. gr Used to produce readable output that is to be used by Win32 command prompt applications.
  201. gs Used to specify the non-key columns to be added to the leaf level of a nonclustered index.
  202. gt Used to hold a shared lock until the transaction is completed.
  203. gu Used 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.
  204. gv Stored procedure that allows you to estimate the size required for a full backup.
  205. gw Suitable when a query is optimized to get the first row of the result set.
  206. gx Creates a partition function and specifies the number of partitions, partition column and the range of partition column values for each partition.
  207. gy Secondary XML index useful for the .exist() methods
  208. gz ____ is the ____ value for DATAFILETYPE.
  209. ha The uniqueness of data values contained in a column
  210. hb Collects general information on SQL Server connections, stored procedures and T-SQL Statements.
  211. hc The ____ and the ____ cannot be backed up.
  212. hd ____ is what the command prompt utility for Database Engine Tuning is known as.
  213. he Has event classes dealing with the execution of stored procedures.
  214. hf If you create a ____, a unique clustered index on the column will be ____ created.
  215. hg Tells the number of lock requests per second that resulted in deadlock.
  216. hh ____ and ____ should be placed in a different file group on a different physical drive since they are I/O heavy.
  217. hi An ordered collection of backup media, tapes or disk files
  218. hj Recovery model that requires log backups. Permits high-performance bulk copy operations. It is not possible to restore to a specific point in time.
  219. hk Developing a visual representation of the real world problem as an ERD and have the details modeled in terms of entities, attributes and relations.
  220. hl Used to evaluate the selectivity of an index. Shows the current distribution statistic for a particular table and index, or for all tables and indexes.
  221. hm Has event classes produced when DML operators are running.
  222. hn Rebuilds a clustered index but does not rebuild the associated nonclustered indexes unless you use the keyword ALL.
  223. ho Supposed to have the greatest selectivity since only one row can match.
  224. hp A feature that uses a proportional fill mechanism across all the files within each filegroup.
  225. hq An object that provides information about SQL Server locks on resources that prevent concurrent use by different transactions.
  226. hr Gathers information of each T-SQL statement for recreating the same activity in the future.
  227. hs Max number of files and filegroups each for each database
  228. ht The view must reference ____ tables in the ____ as the view.
  229. hu When all the files in a filegroup are full, the ____ will automatically ____ at a time.
  230. hv Secondary XML index useful for performing value-based queries when the full path is not known.
  231. hw Used when compiling and executing queries.
  232. hx Max columns per index file has a ____ value of ____.
  233. hy A set of T-SQL statements that execute against a database using trace files, trace tables, and/or T-SQL scripts.
  234. hz The ____ created on a view must be a ____ clustered one.
  235. ia CHECK constraints work at the ____ to ____values that evaluate to FALSE.
  236. ib Used to single an intent to place locks at lower level. They can be intent shared, intent exclusive, or shared intent exclusive.
  237. ic Tells the number of lock requests per second that timed out, not including NOWAIT locks.
  238. id The maximum size of a data file.
  239. ie A database that is isolated from other databases and the instance of SQL Server that hosts it.
  240. if You can have a maximum of ____ per table.
  241. ig Data values are uncommon and never unique
  242. ih Used to specify the file that is for collecting rows that have formatting errors.
  243. ii Indicated on a result set. Means the query optimizer determined the statistic needs to be updated.
  244. ij The specified temporary table name should not exceed ____.
  245. ik A file, device or a tape used for backups.
  246. il The Management Studio GUI lets you see the Query Execution Plan by selecting either the Display ____ Plan or ____ Execution Plan.
  247. im All temporary tables will be automatically dropped when the ____ is finished or via the ____ command.
  248. in Used to import a data file into a table or view.
  249. io No other transactions can change data and read operations can carry on only with the presence of a NOLOCK hint or read uncommitted isolation level.
  250. ip To move a system database data or log file to a new instance you:
    1. Run ____
    2. Then ____ (NAME = logical name, FILENAME = 'path')
    3. ____
    4. ____
  251. iq Entity Relationship Diagram
  252. ir You should supplement a ____ database back up with a series of ____ database backups.
  253. is Before setting SINGLE_USER mode you must ensure that ____ option is ____.
  254. it You ____ keep compressed and ____ backups in the same ____.
  255. iu Tell the number of lock requests per second that timed out including NOWAIT locks.
  256. iv When on, each executed query will return a regular result set and then an additional result set that details the profile of the query execution.
  257. iw Recovery model that requires log backups and there will be no data loss. Possible to restore to a specific point in time.
  258. ix The ____ 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.
  259. iy Used to produce more in-depth details.
  260. iz ____ date types such as ntext, varchar(max), xml and image ____ be used as the key columns for an index.
  261. ja ____ can never join any filegroup.
  262. jb You ____ add or remove files when ____ is running.
  263. jc Same as HOLDLOCK: Used to hold a shared lock until the transaction is completed.
  264. jd The process of making room for new records.
  265. je SET STATISTICS PROFILE is useful for ____ queries, ____ and ____.
  266. jf A value that can be char, native, widechar, widenative
  267. jg ____ columns are stored as binary large objects and ____ be given an index. Use ____ to produce a primary XML index.
  268. jh Table is portioned based on the frequency of access of columns