NAME

Question types


Start with


Question limit

of 141 available terms

Print test

141 True/False questions

  1. sp_help_jobcountUsed to produce a count on how many jobs a schedule is tied to.

          

  2. SQL Server ProfilerUsed 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 TemplateObject ownership groups

          

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

          

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

          

  6. Default TCP portThe acquired lock is to be applied at the table level

          

  7. sp_start_jobThe ____ is how you make changes to the current user session only.

          

  8. ROWLOCK, PAGLOCK, TABLOCKThere can be ____ transaction ____ levels set at a time.

          

  9. Workload GroupsAre containers for session requests with similar or identical classification criteria.

          

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

          

  11. Should, dynamicallySQL Server ____ be allowed to adjust and use memory ____.

          

  12. Management Studio, sp_configureThe ____ or ____ is how you change memory options manually.

          

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

          

  14. Cannot, credentialPermissions ____ be changed for fixed Server Level Roles.

          

  15. sp_update_jobThe ____ 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, SMTPTo 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 beMore than a ____ instance of SQL server ____ installed at a time.

          

  19. securityadmin roleGranted 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 roleGranted the permission to execute the BULK INSERT statement

          

  21. SchemasObject ownership groups

          

  22. sp_configureUsed to show or change server-level settings

          

  23. Table hintsRefers to an exclusive lock on the table

          

  24. Aggregate monitoring of sessionsYou would use workload groups to ____.

          

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

          

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

          

  27. -g optionUsed 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 mutuallyThe 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. PauseYou will prevent new users from connecting to the Database Engine if you ____ it.

          

  31. SNAPSHOTA 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 statementThe ____ 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_viewUsed to find out further information on the various jobs

          

  36. -f optionUsed 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 LevelsDefinitions 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 TRANSACTIONThe ____ statement, practically, marks the end of a successful implicit or explicit transaction.

          

  40. ROWLOCK hintUpdate locks that are held in place until a transaction is completed.

          

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

          

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

          

  43. CHECK_POLICY optionSpecifics that the password that follows the PASSWORD argument is already hashed

          

  44. -s optionAllows 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. 5The sums of the minimum CPU and minimum memory percentages for all available resource polls cannot go over ____ percent.

          

  47. SET statementYou ____ pause the SQL Server ____.

          

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

          

  49. sys.dm_tran_locksYou can query ____ to find out if there are many locks outstanding.

          

  50. On, default____ is the ____ state for CHECK_POLICY.

          

  51. CredentialsThe CPU and I/O affinities ____ exclusive.

          

  52. Performance bottlenecksLocks commonly cause ____.

          

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

          

  54. CannotObject ownership groups

          

  55. SERIALIZABLEProduces the same effect as setting HOLDLOCK on all tables in the SELECT statement.

          

  56. -c optionUsed 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 AgentA Windows service that listens for incoming requests.

          

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

          

  60. LatchesApplies exclusive locks

          

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

          

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

          

  63. 100Applies exclusive locks

          

  64. HASHED optionSpecifics that the password that follows the PASSWORD argument is already hashed

          

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

          

  66. More restrictedREAD COMMITTED is ____ than READ UNCOMMITTED.

          

  67. TSQL_Duration TemplateCapture statements submitted and their execution time. Used to identify the slower queries.

          

  68. -n optionUsed 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 optionTell whether password expiration policy should be enforced on that login

          

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

          

  73. setupadmin roleGranted the permission to add or removed linked servers

          

  74. Can, triggerThere ____ be more than one ____ defined on the LOGON event.

          

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

          

  76. Database Engine serviceThe 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 optionAllows you to increase the number of extents allocated for each file in a filegroup.

          

  80. Does not, implicit1433

          

  81. RECONFIGURE or RECONFIGURE WITH OVERRIDE statementsYou create a logon trigger with the ____.

          

  82. Cannot, publicYou ____ pause the SQL Server ____.

          

  83. serveradmin roleGranted the permission to execute the BULK INSERT statement

          

  84. Cannot, AgentYou ____ pause the SQL Server ____.

          

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

          

  86. TSQL_Grouped TemplateCapture statements submitted and their execution time. Used to identify the slower queries.

          

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

          

  88. sp_get_schedule_descriptionThe file extension of trace files

          

  89. READ COMMITTEDStatements cannot read data that has been changed but not yet committed.

          

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

          

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

          

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

          

  93. Can, user-definedYou ____ create ____ server level roles.

          

  94. Script LoginAn option in Management Studio, allows you to script a login

          

  95. migrating, serverTo 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 taskUsed for directly affecting the I/O affinity mask.

          

  97. Dynamically, CPUAn affinity mask is used for ____ controlling ____ affinity.

          

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

          

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

          

  100. UPDLOCK hintThe acquired lock is to be applied at the table level

          

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

          

  102. TABLOCKX hintRefers to an exclusive lock on the table

          

  103. Autocommit mode____ is the default transaction management mode.

          

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

          

  105. CompatibilityAn option in Management Studio, allows you to script a login

          

  106. Windows, SQL ServerSpecifies that the login is to be mapped to a Windows login

          

  107. LowerThe max CPU percentage cannot be ____ than the min CPU percentage.

          

  108. Management, resource poolsWorkload groups located under the ____ node - ____ in Management Studio.

          

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

          

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

          

  111. SQL MailThe ____ email system is depreciated.

          

  112. Resource GovernorThe max ____ percentage cannot be lower than the min ____ percentage.

          

  113. PublicThere are ____ fixed Server Level Roles in SQL Server

          

  114. Management StudioThe primary interface for managing the databases.

          

  115. XLOCKUsed to prevent concurrent use of a resource by multiple different transactions

          

  116. .trc extensionThe file extension of trace files

          

  117. CREATE CREDENTIAL, Management StudioThe primary interface for managing the databases.

          

  118. REPEATABLE READStatements 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 poolA feature you can use to specify limits on resource consumption by incoming requests

          

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

          

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

          

  122. sp_help_jobactivityUsed to find out further information on the various jobs

          

  123. affinity masksUsed for directly affecting the I/O affinity mask.

          

  124. Reporting Services Configuration ManagerUsed to configure and manage the reporting services.

          

  125. WINDOWS optionUsed for starting an instance with minimal configuration.

          

  126. One, isolationUsed for starting an instance with minimal configuration.

          

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

          

  128. Off, SNAPSHOTA 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 statementYou create a logon trigger with the ____.

          

  130. bulkadmin roleGranted the permission to manage disk files.

          

  131. Resource GovernorThe ____ 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 roleGranted the permission to manage disk files.

          

  135. TABLOCK hintRefers to an exclusive lock on the table

          

  136. LocksUsed to prevent concurrent use of a resource by multiple different transactions

          

  137. Query WindowProvides a basic editor to write T-SQL statements/scripts

          

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

          

  139. Memory, memoryProvides a basic editor to write T-SQL statements/scripts

          

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

          

  141. sysadmin roleGranted the permission to preform any activity in the server