NAME

Question types


Start with


Question limit

of 141 available terms

Print test

141 True/False questions

  1. sp_help_jobcount → Used to produce a count on how many jobs a schedule is tied to.

          

  2. SQL Server Profiler → Used to utilize captured traces, and capture and save data to analyze later. Can also create templates to define event classes and data columns

          

  3. TSQL Template → Object ownership groups

          

  4. View, Resource Governor → You can reconfigure Resource Governor in Management Studio Under ____ - Template Explorer - ____ - Configure Resource Governor.

          

  5. ALTER SERVER CONFIGURATION, PROCESS AFFINITY → When there a is particular ____ preventing the server from starting is when you most often use the ____ option.

          

  6. Default TCP port → The acquired lock is to be applied at the table level

          

  7. sp_start_job → The ____ is how you make changes to the current user session only.

          

  8. ROWLOCK, PAGLOCK, TABLOCK → There can be ____ transaction ____ levels set at a time.

          

  9. Workload Groups → Are containers for session requests with similar or identical classification criteria.

          

  10. -m option → Allows you to increase the number of extents allocated for each file in a filegroup.

          

  11. Should, dynamically → SQL Server ____ be allowed to adjust and use memory ____.

          

  12. Management Studio, sp_configure → The ____ or ____ is how you change memory options manually.

          

  13. Explicit transaction → ____ is the kind of transaction started with the BEGIN TRANSACTION statement.

          

  14. Cannot, credential → Permissions ____ be changed for fixed Server Level Roles.

          

  15. sp_update_job → The ____ is how you make changes to the current user session only.

          

  16. Event class, trace → ____ instances that you can monitor in the ____ process are what captured events in the Database Engine become.

          

  17. Database, SMTP → To set up ____ Mail you would configure one or more databases as mail hosts and then define client settings so SQL Server Agent can send message via ____ mail server

          

  18. Single, can be → More than a ____ instance of SQL server ____ installed at a time.

          

  19. securityadmin role → Granted the permission to manage logins and their properties, as well as GRANT, DENY, and REVOKE permissions at server-level, and if they have access to database-level permissions. They can reset passwords

          

  20. dbcreator role → Granted the permission to execute the BULK INSERT statement

          

  21. Schemas → Object ownership groups

          

  22. sp_configure → Used to show or change server-level settings

          

  23. Table hints → Refers to an exclusive lock on the table

          

  24. Aggregate monitoring of sessions → You would use workload groups to ____.

          

  25. RECONFIGURE statement → The ____ is how you update current configured values that have been changed with sp_configure.

          

  26. SET IMPLICIT_TRANSACTIONS OFF → The ____ statement, practically, marks the end of a successful implicit or explicit transaction.

          

  27. -g option → Used to specify the size of memory that SQL Server can leave available for allocations within the process outside of the Server memory pool

          

  28. Are mutually → The CPU and I/O affinities ____ exclusive.

          

  29. sysadmin,
    serveradmin
    securityadmin
    processadmin
    setupadmin
    bulkadmin
    diskadmin
    dbcreator
    public     → You can configure processor affinity options in SQL Server 2012 by using the ____ statement and then the ____ argument.

          

  30. Pause → You will prevent new users from connecting to the Database Engine if you ____ it.

          

  31. SNAPSHOT → A transaction can only recognize data modifications committed prior to the start of the transaction. Modifications made after the start will be invisible.

          

  32. The Standard Template → ____ is the default template for SQL Server Profiler.

          

  33. ALTER DATABASE statement → The ____ is how you change Database level settings.

          

  34. User must change password at next login
    Enforce password expiration
    Enforce password policy     → ____ are the optional password policies available. (3)

          

  35. sysjobs_view → Used to find out further information on the various jobs

          

  36. -f option → Used to specify the size of memory that SQL Server can leave available for allocations within the process outside of the Server memory pool

          

  37. Transaction Isolation Levels → Definitions of the types of locks that can be acquired on read operations.

          

  38. CREATE WORKLOAD GROUP, ALTER RESOURCE GOVERNOR RECONFIGURE → ____ and ____ are the two T-SQL statements that are needed to make a new workload group,

          

  39. COMMIT TRANSACTION → The ____ statement, practically, marks the end of a successful implicit or explicit transaction.

          

  40. ROWLOCK hint → Update locks that are held in place until a transaction is completed.

          

  41. READ UNCOMMITTED level → Will not issue shared locks. They are not blocked by exclusive locks, and it means dirty reads.

          

  42. MUST_CHANGE option → Says the Windows password policies of the local server computer should be enforced on this particular login.

          

  43. CHECK_POLICY option → Specifics that the password that follows the PASSWORD argument is already hashed

          

  44. -s option → Allows you to start only a named instance of SQL Server

          

  45. CREATE RESOURCE POOL, ALTER RESOURCE GOVERNOR RECONFIGURE → ____ then ____ are the two T-SQL statements that are needed for creating resource pools.

          

  46. 5 → The sums of the minimum CPU and minimum memory percentages for all available resource polls cannot go over ____ percent.

          

  47. SET statement → You ____ pause the SQL Server ____.

          

  48. ROLLBACK TRANSACTION statement → Removes all data modifications made and rolls back to the beginning of the transaction

          

  49. sys.dm_tran_locks → You can query ____ to find out if there are many locks outstanding.

          

  50. On, default → ____ is the ____ state for CHECK_POLICY.

          

  51. Credentials → The CPU and I/O affinities ____ exclusive.

          

  52. Performance bottlenecks → Locks commonly cause ____.

          

  53. SQL Server Agent, automation → You would use ____ for database ____. Designed for processing alerts, and running scheduled jobs. Can also send out relevant alerts and notifications through email

          

  54. Cannot → Object ownership groups

          

  55. SERIALIZABLE → Produces the same effect as setting HOLDLOCK on all tables in the SELECT statement.

          

  56. -c option → Used for shortening the startup time when starting SQL Server from the command prompt

          

  57. BEGIN TRANSACTION, SET IMPLICIT_TRANSACTIONS → ____ is what is started with the SET IMPLICIT_TRANSACTIONS statement.

          

  58. SQL Server Agent → A Windows service that listens for incoming requests.

          

  59. Authentication, user session → After ____ is finished and before the ____ is established is when logon triggers fire.

          

  60. Latches → Applies exclusive locks

          

  61. Standard, TSQL, TSQL_Duration, TSQL_Grouped, TSQL_SPs → ____ are the predefined templates for SQL Server Profiler (5)

          

  62. File system, filegroups → In the ____, in files, and often group into ____ is how databases are stored

          

  63. 100 → Applies exclusive locks

          

  64. HASHED option → Specifics that the password that follows the PASSWORD argument is already hashed

          

  65. READ COMMITTED → Will not issue shared locks. They are not blocked by exclusive locks, and it means dirty reads.

          

  66. More restricted → READ COMMITTED is ____ than READ UNCOMMITTED.

          

  67. TSQL_Duration Template → Capture statements submitted and their execution time. Used to identify the slower queries.

          

  68. -n option → Used for shortening the startup time when starting SQL Server from the command prompt

          

  69. Increase concurrency and improve performance → ____ statement or ____ are two ways to set up credentials.

          

  70. Affinity mask, affinity I/O mask → ____ and ____ are the two affinity mask options.

          

  71. CHECK_EXPIRATION option → Tell whether password expiration policy should be enforced on that login

          

  72. Database Mail or SQL Mail → The executable process of the SQL Server Database Engine.

          

  73. setupadmin role → Granted the permission to add or removed linked servers

          

  74. Can, trigger → There ____ be more than one ____ defined on the LOGON event.

          

  75. SET TRANSACTION ISOLATION LEVEL → Definitions of the types of locks that can be acquired on read operations.

          

  76. Database Engine service → The executable process of the SQL Server Database Engine.

          

  77. Don't have → ____ is the default transaction management mode.

          

  78. Pausing, does not → ____ the Database Engine service ____ remove users currently connected.

          

  79. -E option → Allows you to increase the number of extents allocated for each file in a filegroup.

          

  80. Does not, implicit → 1433

          

  81. RECONFIGURE or RECONFIGURE WITH OVERRIDE statements → You create a logon trigger with the ____.

          

  82. Cannot, public → You ____ pause the SQL Server ____.

          

  83. serveradmin role → Granted the permission to execute the BULK INSERT statement

          

  84. Cannot, Agent → You ____ pause the SQL Server ____.

          

  85. Standard Template → Captures all the stored procedures and T-SQL batches that are run. Used to monitor the general database server activities

          

  86. TSQL_Grouped Template → Capture statements submitted and their execution time. Used to identify the slower queries.

          

  87. Configuration values, -f → When there a is particular ____ preventing the server from starting is when you most often use the ____ option.

          

  88. sp_get_schedule_description → The file extension of trace files

          

  89. READ COMMITTED → Statements cannot read data that has been changed but not yet committed.

          

  90. Implicit transaction mode → The ____ statement, practically, marks the end of a successful implicit or explicit transaction.

          

  91. processadmin role → A mode that means every T-SQL statement will be committed or rolled back when it is completed.

          

  92. One, Browser → You need ____ SQL Server ____ for all SQL Server instances installed on the same server.

          

  93. Can, user-defined → You ____ create ____ server level roles.

          

  94. Script Login → An option in Management Studio, allows you to script a login

          

  95. migrating, server → To set up ____ Mail you would configure one or more databases as mail hosts and then define client settings so SQL Server Agent can send message via ____ mail server

          

  96. I/O affinity task → Used for directly affecting the I/O affinity mask.

          

  97. Dynamically, CPU → An affinity mask is used for ____ controlling ____ affinity.

          

  98. SQL Server Browser → Granted the permission to change server-wide configuration options and shut down the server

          

  99. SQL Server Configuration Manager → Used to manage the SQL server instances and set up the clients/client protocols.

          

  100. UPDLOCK hint → The acquired lock is to be applied at the table level

          

  101. Right-click, Properties → The HASHED argument should be used only when ____ databases from one ____ to another.

          

  102. TABLOCKX hint → Refers to an exclusive lock on the table

          

  103. Autocommit mode → ____ is the default transaction management mode.

          

  104. sp_configure, all, GUI, most commonly → SQL Server ____ be allowed to adjust and use memory ____.

          

  105. Compatibility → An option in Management Studio, allows you to script a login

          

  106. Windows, SQL Server → Specifies that the login is to be mapped to a Windows login

          

  107. Lower → The max CPU percentage cannot be ____ than the min CPU percentage.

          

  108. Management, resource pools → Workload groups located under the ____ node - ____ in Management Studio.

          

  109. Management Studio, CREATE LOGIN → The ____ or ____ statement are two ways to configure logins and their passwords.

          

  110. Logon Triggers → Triggers that can fire stored procedures when a LOGON event is raised.

          

  111. SQL Mail → The ____ email system is depreciated.

          

  112. Resource Governor → The max ____ percentage cannot be lower than the min ____ percentage.

          

  113. Public → There are ____ fixed Server Level Roles in SQL Server

          

  114. Management Studio → The primary interface for managing the databases.

          

  115. XLOCK → Used to prevent concurrent use of a resource by multiple different transactions

          

  116. .trc extension → The file extension of trace files

          

  117. CREATE CREDENTIAL, Management Studio → The primary interface for managing the databases.

          

  118. REPEATABLE READ → Statements cannot read data modified but not yet committed and no other transactions can modify data that has been read until current transaction is completed.

          

  119. Resource pool → A feature you can use to specify limits on resource consumption by incoming requests

          

  120. TSQL_SPs Template → Captures all statements submitted with information grouped by the client that submitted it. Use it to investigate queries from specific clients.

          

  121. Autocommit mode → A mode that means every T-SQL statement will be committed or rolled back when it is completed.

          

  122. sp_help_jobactivity → Used to find out further information on the various jobs

          

  123. affinity masks → Used for directly affecting the I/O affinity mask.

          

  124. Reporting Services Configuration Manager → Used to configure and manage the reporting services.

          

  125. WINDOWS option → Used for starting an instance with minimal configuration.

          

  126. One, isolation → Used for starting an instance with minimal configuration.

          

  127. 9 → Used to prevent concurrent use of a resource by multiple different transactions

          

  128. Off, SNAPSHOT → A transaction can only recognize data modifications committed prior to the start of the transaction. Modifications made after the start will be invisible.

          

  129. CREATE TRIGGER statement → You create a logon trigger with the ____.

          

  130. bulkadmin role → Granted the permission to manage disk files.

          

  131. Resource Governor → The ____ can be used in real time.

          

  132. Client Application Name → ____ instances that you can monitor in the ____ process are what captured events in the Database Engine become.

          

  133. Off, default → ____ is the ____ state for the CHECK-EXPIRATION option.

          

  134. diskadmin role → Granted the permission to manage disk files.

          

  135. TABLOCK hint → Refers to an exclusive lock on the table

          

  136. Locks → Used to prevent concurrent use of a resource by multiple different transactions

          

  137. Query Window → Provides a basic editor to write T-SQL statements/scripts

          

  138. Older applications, third-party, mixed operating systems → If you need to provide support for ____, ____ applications, or if you have ____ in place is when you would use SQL Server Authentication.

          

  139. Memory, memory → Provides a basic editor to write T-SQL statements/scripts

          

  140. ALTER RESOURCE GOVERNOR RECONFIGURE, Management node → The ____ is how you change Database level settings.

          

  141. sysadmin role → Granted the permission to preform any activity in the server