NAME

Question types


Start with


Question limit

of 122 available terms

Print test

122 True/False questions

  1. Self joinUsed to return the product but not the sum of the two sources. Returns the set of all possible row combinations.

          

  2. db_datareader, sysadmin, SELECTMembers of the ____/db_owner fixed database roles or the ____ fixed server fol can always run ____ at wish.

          

  3. Only one, INSERT, DELETEInner joins can be specified in the ____ clause or the ____ clause. Outer joins can be specified only in the ____ clause.

          

  4. 1024Gives the highest value in an expression

          

  5. Full-text queriesCan be issued against character-based data in a table when there is a full-text index on that table.

          

  6. TRUNCATE TABLEUsed to delete all rows from a table without logging the individual row deletions.

          

  7. ORDER BY, TOPOnly a specified first set or percent of rows can be returned.

          

  8. HAVINGUsed for specifying search conditions for a group or an aggregate.

          

  9. Cannot, FOREIGN KEY, itselfYou ____ run TRUNCATE TABLE on tables that are referenced by a ____ constraint unless it is referencing ____.

          

  10. Only one, referenceCREATE TRIGGER can apply to ____ table in the current database, though it can ____ objects in another.

          

  11. SELECT permissionUsed to join a table/view to itself.

          

  12. DATEADDUsed to produce a new date/time value which is based on adding an interval to the concerned date.

          

  13. BEGIN TRAN, COMMIT TRANTo perform multi-statement transactions you need a ____ at the beginning and a ____ at the end.

          

  14. db_owner, db_ddladminSubqueries can have an ____ clause when a ____ clause is also used.

          

  15. EXECUTE AS argumentFor explicitly specifying the security context under which the current trigger fires.

          

  16. SequenceA user-defined schema bound object for generating a sequence of numeric values.

          

  17. Left, right, fullIf CREATE TRIGGER is part of a ____, it must be the ____ statement.

          

  18. MAXVALUEUsed to specify upper bounds for the sequence object.

          

  19. SELECT TOP, ORDER BYIt is recommended whenever you use the ____ statement you use the ____ clause to indicate the rows that are to be affected.

          

  20. RAW modeUsed to specify that updates be allowed when you view data under a DB-Library browse mode cursor.

          

  21. Severity 20 or higherWill directly close the database connection without invoking CATCH.

          

  22. MINVALUEUsed to specify upper bounds for the sequence object.

          

  23. CREATE TRIGGERUsed to create a trigger, which is a special kind of stored procedure that will automatically run when an event takes place.

          

  24. DML triggersResults of the query will be returned as an XML document.

          

  25. Cannot, indexed view, fireYou ____ run TRUNCATE TABLE on tables that participate in an ____ and they cannot ____ any trigger.

          

  26. Sequence, not tiedtinyint
    smallint
    int
    bigint

          

  27. UNIONUsed 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.

          

  28. TRY...CATCHBlock of code used for processing errors in T-SQL code.

          

  29. Cascade, ConstraintUsed to combine and add records from two sources to a query's results when the values can meet the criteria defined.

          

  30. Right outer joinUsed to combine rows from two sources where all of the right side rows will be included.

          

  31. Data manipulation language (DML)Used to run queries and add, delete or edit records.

          

  32. Cross joinUsed to return the product but not the sum of the two sources. Returns the set of all possible row combinations.

          

  33. ORDER BYUsed to order the result set of a query and at the same time limit the rows that are returned.

          

  34. INSTEAD OF argumentSpecifies that the DML trigger can be fired only when all operations in the triggering statement are successfully completed.

          

  35. LIKEGives the lowest value in an expression

          

  36. SET NO_BROWSETABLE ONUsed to set NO_BROWSETABLE to function.

          

  37. Database, ALTER ANY DATABASEYou can create a DDL trigger with ____ scope if you have ____ DDL TRIGGER permission in the current database.

          

  38. COMPUTE, FOR BROWSEUsed to create a sequence.

          

  39. Distributed Transaction Coordinator (DTC)Windows server service that can coordinate transactions that update multiple transaction protected resources on a single server computer or distributed across networked server computers.

          

  40. JoinsGives the lowest value in an expression

          

  41. FETCHUsed to specify the number of rows to return as soon as the OFFSET is processed.

          

  42. CREATE VIEWUsed to create a view.

          

  43. COUNT(), performingAll referential ____ actions and ____ checks must succeed before a DML trigger fires.

          

  44. COMPUTEUsed to generate subtotals in a result set. ntext, text and image cannot be dealt with through these.

          

  45. COLLATEUsed to generate subtotals in a result set. ntext, text and image cannot be dealt with through these.

          

  46. MAXProduces the total of all values in a numeric expression.

          

  47. UNBOUNDED PRECEDINGThe window will start at the first row of the partition.

          

  48. Current, first statementAll referential ____ actions and ____ checks must succeed before a DML trigger fires.

          

  49. OFFSETUsed to specify the number of rows to be skipped.

          

  50. AUTO modeSupports nesting in the resulting XML.

          

  51. Inner joinUsed to return all rows from the joined tables/views even where there is no matching row between them.

          

  52. ROLLBACK TRANUsed to undo all of the work since the last BEGIN TRAN statement.

          

  53. Left outer joinUsed to combine and add records from two sources to a query's results when the values can meet the criteria defined.

          

  54. OVERComputes the average of all values in a numeric expression.

          

  55. Cannot, partitionedYou ____ use SELECT....INTO to create a ____ table.

          

  56. Compute row aggregate functionsRANK
    NTILE
    DENSE_RANK
    ROW_NUMBER

          

  57. Data definition language (DDL)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.

          

  58. SubqueryAn inner select, which is always enclosed in parentheses.

          

  59. PARTITION BYArgument for telling the windows function to be applied to each partition separately and that computation will be restarted for each partition.

          

  60. Outer joinUsed to combine and add records from two sources to a query's results when the values can meet the criteria defined.

          

  61. Aggregate functions, single, ignoreUse ____ 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.

          

  62. Severity 10 or lowerWill directly close the database connection without invoking CATCH.

          

  63. db_owner, db_datawriterYou can create a ____ trigger if you have ____ permission on the table or view it will be created on.

          

  64. Logical processing orderFROM
    ON
    JOIN
    WHERE
    GROUP BY
    WITH CUBE or WITH ROLLUP
    HAVING
    SELECT
    DISTINCT
    ORDER BY
    TOP

          

  65. Batch, firstUsed to produce and integer that forms a specified part of a date.

          

  66. Sequence value typesUsed to delete all rows from a table without logging the individual row deletions.

          

  67. SUMUsed to specify either the BROWSE or the XML option.

          

  68. AFTER argumentSpecifies that the DML trigger can be fired only when all operations in the triggering statement are successfully completed.

          

  69. Nested, 32Used to produce the number of date/time boundaries that get crossed between two different dates.

          

  70. Mutual Authentication RequiredCan be issued against character-based data in a table when there is a full-text index on that table.

          

  71. FOR BROWSECannot be used in SELECT statements joined by the UNION operator.

          

  72. Aggregate functionsAVG
    MIN
    CHECKSUM_AGG
    SUM
    COUNT
    STDEV
    COUNT_BIG
    STDEVP
    GROUPING
    VAR
    GROUPING_ID
    VARP
    MAX

          

  73. DATABASE argumentResults of the query will be returned as an XML document.

          

  74. TOPUsed to specify either the BROWSE or the XML option.

          

  75. EXPLICIT modeGives more control over how the XML results are formatted.

          

  76. GROUPING SETS()Used to retrieve data from two or more tables or views.

          

  77. CONTAINSSpecified in the WHERE or HAVING clauses. Used for precise or fuzzy matches.

          

  78. FROM, WHERE, FROMInner joins can be specified in the ____ clause or the ____ clause. Outer joins can be specified only in the ____ clause.

          

  79. CREATE SEQUENCEA user-defined schema bound object for generating a sequence of numeric values.

          

  80. TransactionUsed 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.

          

  81. MINGives the lowest value in an expression

          

  82. COUNTGives the exact number of selected rows

          

  83. BROWSEUsed to specify that updates be allowed when you view data under a DB-Library browse mode cursor.

          

  84. AtomicGives the lowest value in an expression

          

  85. ALL SERVER argumentUsed to specify that the DML trigger is to be executed instead of the triggering statement. Cannot be used for DDL or logon triggers.

          

  86. Directly, indirectly, SUBSTRINGCannot have tables joined ____ on ntext, test, or image columns. However, this can be done ____ using ____.

          

  87. Analytic functionsSpecified in the WHERE or HAVING clauses. Used for precise or fuzzy matches.

          

  88. GETDATEUsed to retrieve the current date and time in SQL Server.

          

  89. HAVING, SELECTUsed for specifying search conditions for a group or an aggregate.

          

  90. FREETEXTTABLEUsed to delete all rows from a table without logging the individual row deletions.

          

  91. DATEPARTUsed to produce and integer that forms a specified part of a date.

          

  92. START WITHOption 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.

          

  93. Ranking functionsAVG
    MIN
    CHECKSUM_AGG
    SUM
    COUNT
    STDEV
    COUNT_BIG
    STDEVP
    GROUPING
    VAR
    GROUPING_ID
    VARP
    MAX

          

  94. THROWAn alternative to RAISERROR. Can raise an exception and transfer execution to CATCH within TRY...CATCH block. Will cause a statement batch to end.

          

  95. Server, logon, CONTROL SERVERYou can create a DDL trigger with ____ scope or a ____ trigger if you have ____ permission on the server.

          

  96. WITH CHECK OPTIONUsed to combine and add records from two sources to a query's results when the values can meet the criteria defined.

          

  97. DML, ALTERYou can create a ____ trigger if you have ____ permission on the table or view it will be created on.

          

  98. Permissions, table, sysadmin, db_ddladminTRUNCATE TABLE ____ are granted to the ____ owner, the members of the ____ fixed server role and the db_owner/____ fixed database roles.

          

  99. WITH ENCRYPTION argumentFor explicitly specifying the security context under which the current trigger fires.

          

  100. CATCHWhere the error can be dealt with. Once dealt with control will be transferred to the first statement after END CATCH.

          

  101. SCHEMABINDINGUsed to ensure that the base table cannot be modified to affect the view definition.

          

  102. CYCLEUsed to tell the sequence object if the sequence should restart. Default is NO.

          

  103. Severity 11 to 19Control will be transferred to the associated CATCH block. Can provide information on the error that caused the CATCH block to run.

          

  104. Ranking functions, partitionUse ____ to return a ranking value for each row within a ____. They are nondeterministic.

          

  105. Analytic functions, compute thingsTo perform multi-statement transactions you need a ____ at the beginning and a ____ at the end.

          

  106. DISTINCTUsed for specifying search conditions for a group or an aggregate.

          

  107. FREETEXTSpecified in the WHERE or HAVING clauses. Used to match the meaning of words, phrases and strings.

          

  108. ROLLUP()Used to specify that operation should be performed following a different collation.

          

  109. 32 levelsThere is a maximum of ____ of nesting possible with subqueries.

          

  110. XML argumentResults of the query will be returned as an XML document.

          

  111. SELECT...INTOCan be inherited from the schema permissions or CONTROL permissions on a table.

          

  112. AVGGives the lowest value in an expression

          

  113. DATEDIFFUsed to produce the number of date/time boundaries that get crossed between two different dates.

          

  114. GROUP BYUsed to order the result set of a query and at the same time limit the rows that are returned.

          

  115. Logon triggersUsed to create a trigger, which is a special kind of stored procedure that will automatically run when an event takes place.

          

  116. FORGives the exact number of selected rows

          

  117. Nested, sp_configureDisable nested triggers by setting the ____ triggers options of ____ to a value of 0.

          

  118. NO_BROWSETABLEOption to turn on so that all the SELECT statements will behave as if the FOR BROWSE option has been appended to the statements.

          

  119. RAISERRORUsed to determine the partitioning and ordering of a rowset before allowing the associated window function to be applied.

          

  120. Full outer joinUsed to retrieve all the rows from both sides where the join condition is evaluated to true.

          

  121. CONTAINSTABLEUsed to delete all rows from a table without logging the individual row deletions.

          

  122. INCREMENT BYSpecified in the WHERE or HAVING clauses. Used to match the meaning of words, phrases and strings.