NAME

Question types


Start with


Question limit

of 122 available terms

Print test

122 Matching questions

  1. Database, ALTER ANY DATABASE
  2. Cross join
  3. Data definition language (DDL)
  4. SELECT...INTO
  5. Compute row aggregate functions
  6. RAISERROR
  7. Severity 11 to 19
  8. Full outer join
  9. CONTAINSTABLE
  10. TOP
  11. 32 levels
  12. Joins
  13. FREETEXT
  14. DATEDIFF
  15. PARTITION BY
  16. SUM
  17. Current, first statement
  18. MAX
  19. ORDER BY, TOP
  20. FREETEXTTABLE
  21. DML, ALTER
  22. Outer join
  23. Cannot, FOREIGN KEY, itself
  24. Aggregate functions, single, ignore
  25. Full-text queries
  26. CATCH
  27. WITH ENCRYPTION argument
  28. EXECUTE AS argument
  29. GETDATE
  30. FOR
  31. CREATE SEQUENCE
  32. Data manipulation language (DML)
  33. SELECT TOP, ORDER BY
  34. CYCLE
  35. TRUNCATE TABLE
  36. MIN
  37. Sequence
  38. Right outer join
  39. AFTER argument
  40. AUTO mode
  41. THROW
  42. Nested, sp_configure
  43. MINVALUE
  44. Nested, 32
  45. db_owner, db_ddladmin
  46. Analytic functions, compute things
  47. COUNT(), performing
  48. Atomic
  49. NO_BROWSETABLE
  50. INSTEAD OF argument
  51. AVG
  52. COUNT
  53. COMPUTE
  54. Left, right, full
  55. UNBOUNDED PRECEDING
  56. Aggregate functions
  57. Self join
  58. OFFSET
  59. Analytic functions
  60. INCREMENT BY
  61. Server, logon, CONTROL SERVER
  62. Left outer join
  63. Cascade, Constraint
  64. EXPLICIT mode
  65. Transaction
  66. LIKE
  67. SELECT permission
  68. Cannot, partitioned
  69. OVER
  70. Ranking functions, partition
  71. WITH CHECK OPTION
  72. CREATE TRIGGER
  73. MAXVALUE
  74. DATEADD
  75. FOR BROWSE
  76. GROUPING SETS()
  77. Subquery
  78. SCHEMABINDING
  79. FETCH
  80. Sequence, not tied
  81. ORDER BY
  82. Inner join
  83. Mutual Authentication Required
  84. Only one, INSERT, DELETE
  85. CREATE VIEW
  86. XML argument
  87. Logical processing order
  88. Only one, reference
  89. RAW mode
  90. SET NO_BROWSETABLE ON
  91. Logon triggers
  92. HAVING
  93. START WITH
  94. TRY...CATCH
  95. FROM, WHERE, FROM
  96. DATEPART
  97. Permissions, table, sysadmin, db_ddladmin
  98. Directly, indirectly, SUBSTRING
  99. DATABASE argument
  100. Batch, first
  101. Distributed Transaction Coordinator (DTC)
  102. HAVING, SELECT
  103. Severity 10 or lower
  104. db_datareader, sysadmin, SELECT
  105. COMPUTE, FOR BROWSE
  106. Ranking functions
  107. 1024
  108. GROUP BY
  109. BEGIN TRAN, COMMIT TRAN
  110. Sequence value types
  111. ALL SERVER argument
  112. Cannot, indexed view, fire
  113. CONTAINS
  114. UNION
  115. DML triggers
  116. COLLATE
  117. DISTINCT
  118. ROLLUP()
  119. ROLLBACK TRAN
  120. Severity 20 or higher
  121. BROWSE
  122. db_owner, db_datawriter
  1. a Gives the exact number of selected rows
  2. b You can create a view only in the ____ database and CREATE VIEW must be the ____ in the query.
  3. c Used to specify the number of rows to return as soon as the OFFSET is processed.
  4. d Used to undo all of the work since the last BEGIN TRAN statement.
  5. e Used to invoke when a user modifies data through DML.
  6. f FROM
    ON
    JOIN
    WHERE
    GROUP BY
    WITH CUBE or WITH ROLLUP
    HAVING
    SELECT
    DISTINCT
    ORDER BY
    TOP
  7. g Computes the average of all values in a numeric expression.
  8. h Block of code used for processing errors in T-SQL code.
  9. i Used to create a trigger, which is a special kind of stored procedure that will automatically run when an event takes place.
  10. j ____ INSTEAD OF trigger per ____, UPDATE or ____ statement on a table/view.
  11. k Used to set NO_BROWSETABLE to function.
  12. l Users with the ____ and ____ fixed database roles may also update sequence objects.
  13. m You can create a DDL trigger with ____ scope or a ____ trigger if you have ____ permission on the server.
  14. n Used to fine-tune error-handling. Can have multiple severities that will handle the errors differently.
  15. o Used to generate subtotals in a result set. ntext, text and image cannot be dealt with through these.
  16. p tinyint
    smallint
    int
    bigint
  17. q Special triggers that fire primarily in response to the LOGON event, which is raised only when a user session is getting established.
  18. r Members of the ____/db_owner fixed database roles or the ____ fixed server fol can always run ____ at wish.
  19. s Will directly close the database connection without invoking CATCH.
  20. t AVG
    COUNT
    MAX
    MIN
    SUM
  21. u A user-defined schema bound object for generating a sequence of numeric values.
  22. v All referential ____ actions and ____ checks must succeed before a DML trigger fires.
  23. w TRUNCATE TABLE ____ are granted to the ____ owner, the members of the ____ fixed server role and the db_owner/____ fixed database roles.
  24. x Used to specify lower bounds for the sequence object.
  25. y Will only return an informational message to the batch without invoking CATCH.
  26. z The window will start at the first row of the partition.
  27. aa Used to combine rows from two sources where all of the right side rows will be included.
  28. ab To perform multi-statement transactions you need a ____ at the beginning and a ____ at the end.
  29. ac Generates a single <row> element per row in the returned rowset.
  30. ad You can create a DDL trigger with ____ scope if you have ____ DDL TRIGGER permission in the current database.
  31. ae Used to specify the number of rows to be skipped.
  32. af Used to specify a value increment or decrement in the sequence object.
  33. ag You should not use the ____ aggregate in a subquery for ____ an existence check.
  34. ah Used to specify that updates be allowed when you view data under a DB-Library browse mode cursor.
  35. ai Used to produce and integer that forms a specified part of a date.
  36. aj It is recommended whenever you use the ____ statement you use the ____ clause to indicate the rows that are to be affected.
  37. ak Users with the ____ and the ____ fixed database roles may create, alter and drop sequence objects.
  38. al Used to retrieve data from two or more tables or views.
  39. am Used to run queries and add, delete or edit records.
  40. an Used to produce a new date/time value which is based on adding an interval to the concerned date.
  41. ao Produces the total of all values in a numeric expression.
  42. ap Used to join a table/view to itself.
  43. aq Cannot have tables joined ____ on ntext, test, or image columns. However, this can be done ____ using ____.
  44. ar Used to retrieve the current date and time in SQL Server.
  45. as Specified in the WHERE or HAVING clauses. Used for precise or fuzzy matches.
  46. at The highest secured communication mode you can use in a non-clustered setup.
  47. au You can create a ____ trigger if you have ____ permission on the table or view it will be created on.
  48. av Used to order the result set of a query and at the same time limit the rows that are returned.
  49. aw There is a maximum of ____ of nesting possible with subqueries.
  50. ax Gives the highest value in an expression
  51. ay Argument that can be used to specify multiple groupings of data in a single query.
  52. az Use ____ to compute an aggregate value based on a group of row. It is possible for them to return more than one row for each group. Use them to ____ things like moving averages, percentages, etc.
  53. ba You ____ run TRUNCATE TABLE on tables that participate in an ____ and they cannot ____ any trigger.
  54. bb The DDL trigger is for applying to the entire database.
  55. bc Used to retrieve all the rows from both sides where the join condition is evaluated to true.
  56. bd Rowset-valued function that is referenced like a table for using CONTAINS type search.
  57. be An alternative to RAISERROR. Can raise an exception and transfer execution to CATCH within TRY...CATCH block. Will cause a statement batch to end.
  58. bf Supports nesting in the resulting XML.
  59. bg Used to return the product but not the sum of the two sources. Returns the set of all possible row combinations.
  60. bh Argument for telling the windows function to be applied to each partition separately and that computation will be restarted for each partition.
  61. bi Used to specify upper bounds for the sequence object.
  62. bj There are three types of outer joins: ____, ____, and ____.
  63. bk The DDL/logon trigger is to be applied to the current server.
  64. bl Used to prevent the trigger from being published during replication.
  65. bm AVG
    MIN
    CHECKSUM_AGG
    SUM
    COUNT
    STDEV
    COUNT_BIG
    STDEVP
    GROUPING
    VAR
    GROUPING_ID
    VARP
    MAX
  66. bn Used to ensure that the base table cannot be modified to affect the view definition.
  67. bo A new view can have a maximum of ____ columns.
  68. bp An inner select, which is always enclosed in parentheses.
  69. bq Subqueries cannot have any ____ or ____ clauses.
  70. br Used to specify that the DML trigger is to be executed instead of the triggering statement. Cannot be used for DDL or logon triggers.
  71. bs Used to combine the results of multiple queries into a single result set which includes all the rows that belong to all queries participating. Removes duplicates unless ALL is included.
  72. bt Only unique rows can appear in the result set.
  73. bu Used to combine rows from two sources where all of the left side rows will be included.
  74. bv Used to combine and add records from two sources to a query's results when the values can meet the criteria defined.
  75. bw Gives more control over how the XML results are formatted.
  76. bx Option to turn on so that all the SELECT statements will behave as if the FOR BROWSE option has been appended to the statements.
  77. by Where the error can be dealt with. Once dealt with control will be transferred to the first statement after END CATCH.
  78. bz Used to produce the number of date/time boundaries that get crossed between two different dates.
  79. ca Windows server service that can coordinate transactions that update multiple transaction protected resources on a single server computer or distributed across networked server computers.
  80. cb Results of the query will be returned as an XML document.
  81. cc Used to create and delete databases/tables, define table rows and columns, create indexes and take other actions that change the structure of the database.
  82. cd For explicitly specifying the security context under which the current trigger fires.
  83. ce Used to group a selected set of rows into a set of summary rows by the values of columns or expressions.
  84. cf A ____ is ____ to any table.
  85. cg Use ____ to return a ranking value for each row within a ____. They are nondeterministic.
  86. ch Only a specified first set or percent of rows can be returned.
  87. ci CUME_DIST
    LEAD
    FIRST_VALUE
    PERCENTILE_CONT
    LAG
    PERCENTILE_DISC
    LAST_VALUE
    PERCENT_RANK
  88. cj You ____ run TRUNCATE TABLE on tables that are referenced by a ____ constraint unless it is referencing ____.
  89. ck Rowset-valued function that is referenced like a table for using FREETEXT type search.
  90. cl Specifies that the DML trigger can be fired only when all operations in the triggering statement are successfully completed.
  91. cm Used to ensure that no changes to the underlying data can be made through the view that would cause the data to not conform to the definition. Can also be used to ensure the data will remain visible through the view when modified through the view.
  92. cn If CREATE TRIGGER is part of a ____, it must be the ____ statement.
  93. co Used to determine the partitioning and ordering of a rowset before allowing the associated window function to be applied.
  94. cp Means that every piece of work in the transaction is an integral part of a single unit. All works within the transaction much complete for it to be considered as committed.
  95. cq Inner joins can be specified in the ____ clause or the ____ clause. Outer joins can be specified only in the ____ clause.
  96. cr Used to delete all rows from a table without logging the individual row deletions.
  97. cs Used to tell the sequence object if the sequence should restart. Default is NO.
  98. ct Used to create a view.
  99. cu Use ____ to calculate on a set of values in order to return a ____ value. They generate summary values in query results set. Other than COUNT they will ____ null values by default. They are all deterministic.
  100. cv Used to create a new table in the default filegroup with the insertion of the resulting rows from the query into it.
  101. cw Option that can be used to specify a value less than or equal to the maximum and greater than or equal to the minimum value specified.
  102. cx Used to specify either the BROWSE or the XML option.
  103. cy By default triggers can be ____ up to a maximum of ___ levels.
  104. cz Used in a regular SELECT and WHERE class to find a specified pattern in a column.
  105. da Can be inherited from the schema permissions or CONTROL permissions on a table.
  106. db Control will be transferred to the associated CATCH block. Can provide information on the error that caused the CATCH block to run.
  107. dc Cannot be used in SELECT statements joined by the UNION operator.
  108. dd Subqueries can have an ____ clause when a ____ clause is also used.
  109. de Disable nested triggers by setting the ____ triggers options of ____ to a value of 0.
  110. df Used for specifying search conditions for a group or an aggregate.
  111. dg Specified in the WHERE or HAVING clauses. Used to match the meaning of words, phrases and strings.
  112. dh You ____ use SELECT....INTO to create a ____ table.
  113. di Argument that can be used to generate the simple GROUP BY aggregate rows as well as the subtotal/super-aggregate rows and also a grand total row.
  114. dj You can use ____ only with a ____ statement. May want to use it inside a GROUP BY clause, and text, image and ntext's cannot be used.
  115. dk RANK
    NTILE
    DENSE_RANK
    ROW_NUMBER
  116. dl Can be issued against character-based data in a table when there is a full-text index on that table.
  117. dm A sequence of operations performed as a single logical unit of work.
  118. dn Used to create a sequence.
  119. do Used to return all rows from the joined tables/views even where there is no matching row between them.
  120. dp CREATE TRIGGER can apply to ____ table in the current database, though it can ____ objects in another.
  121. dq Used to specify that operation should be performed following a different collation.
  122. dr Gives the lowest value in an expression