NAME

Question types


Start with


Question limit

of 122 available terms

Print test

122 True/False questions

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

          

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

          

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

          

  4. 1024 → Gives the highest value in an expression

          

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

          

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

          

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

          

  8. HAVING → Used for specifying search conditions for a group or an aggregate.

          

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

          

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

          

  11. SELECT permission → Used to join a table/view to itself.

          

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

          

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

          

  14. db_owner, db_ddladmin → Subqueries can have an ____ clause when a ____ clause is also used.

          

  15. EXECUTE AS argument → For explicitly specifying the security context under which the current trigger fires.

          

  16. Sequence → A user-defined schema bound object for generating a sequence of numeric values.

          

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

          

  18. MAXVALUE → Used to specify upper bounds for the sequence object.

          

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

          

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

          

  21. Severity 20 or higher → Will directly close the database connection without invoking CATCH.

          

  22. MINVALUE → Used to specify upper bounds for the sequence object.

          

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

          

  24. DML triggers → Results of the query will be returned as an XML document.

          

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

          

  26. Sequence, not tied → tinyint
    smallint
    int
    bigint

          

  27. UNION → 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.

          

  28. TRY...CATCH → Block of code used for processing errors in T-SQL code.

          

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

          

  30. Right outer join → Used 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 join → Used to return the product but not the sum of the two sources. Returns the set of all possible row combinations.

          

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

          

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

          

  35. LIKE → Gives the lowest value in an expression

          

  36. SET NO_BROWSETABLE ON → Used to set NO_BROWSETABLE to function.

          

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

          

  38. COMPUTE, FOR BROWSE → Used 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. Joins → Gives the lowest value in an expression

          

  41. FETCH → Used to specify the number of rows to return as soon as the OFFSET is processed.

          

  42. CREATE VIEW → Used to create a view.

          

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

          

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

          

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

          

  46. MAX → Produces the total of all values in a numeric expression.

          

  47. UNBOUNDED PRECEDING → The window will start at the first row of the partition.

          

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

          

  49. OFFSET → Used to specify the number of rows to be skipped.

          

  50. AUTO mode → Supports nesting in the resulting XML.

          

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

          

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

          

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

          

  54. OVER → Computes the average of all values in a numeric expression.

          

  55. Cannot, partitioned → You ____ use SELECT....INTO to create a ____ table.

          

  56. Compute row aggregate functions → RANK
    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. Subquery → An inner select, which is always enclosed in parentheses.

          

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

          

  60. Outer join → Used 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, ignore → 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.

          

  62. Severity 10 or lower → Will directly close the database connection without invoking CATCH.

          

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

          

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

          

  65. Batch, first → Used to produce and integer that forms a specified part of a date.

          

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

          

  67. SUM → Used to specify either the BROWSE or the XML option.

          

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

          

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

          

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

          

  71. FOR BROWSE → Cannot be used in SELECT statements joined by the UNION operator.

          

  72. Aggregate functions → AVG
    MIN
    CHECKSUM_AGG
    SUM
    COUNT
    STDEV
    COUNT_BIG
    STDEVP
    GROUPING
    VAR
    GROUPING_ID
    VARP
    MAX

          

  73. DATABASE argument → Results of the query will be returned as an XML document.

          

  74. TOP → Used to specify either the BROWSE or the XML option.

          

  75. EXPLICIT mode → Gives more control over how the XML results are formatted.

          

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

          

  77. CONTAINS → Specified in the WHERE or HAVING clauses. Used for precise or fuzzy matches.

          

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

          

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

          

  80. Transaction → 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.

          

  81. MIN → Gives the lowest value in an expression

          

  82. COUNT → Gives the exact number of selected rows

          

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

          

  84. Atomic → Gives the lowest value in an expression

          

  85. ALL SERVER argument → Used 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, SUBSTRING → Cannot have tables joined ____ on ntext, test, or image columns. However, this can be done ____ using ____.

          

  87. Analytic functions → Specified in the WHERE or HAVING clauses. Used for precise or fuzzy matches.

          

  88. GETDATE → Used to retrieve the current date and time in SQL Server.

          

  89. HAVING, SELECT → Used for specifying search conditions for a group or an aggregate.

          

  90. FREETEXTTABLE → Used to delete all rows from a table without logging the individual row deletions.

          

  91. DATEPART → Used to produce and integer that forms a specified part of a date.

          

  92. START WITH → 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.

          

  93. Ranking functions → AVG
    MIN
    CHECKSUM_AGG
    SUM
    COUNT
    STDEV
    COUNT_BIG
    STDEVP
    GROUPING
    VAR
    GROUPING_ID
    VARP
    MAX

          

  94. THROW → An 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 SERVER → You can create a DDL trigger with ____ scope or a ____ trigger if you have ____ permission on the server.

          

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

          

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

          

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

          

  99. WITH ENCRYPTION argument → For explicitly specifying the security context under which the current trigger fires.

          

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

          

  101. SCHEMABINDING → Used to ensure that the base table cannot be modified to affect the view definition.

          

  102. CYCLE → Used to tell the sequence object if the sequence should restart. Default is NO.

          

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

          

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

          

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

          

  106. DISTINCT → Used for specifying search conditions for a group or an aggregate.

          

  107. FREETEXT → Specified 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 levels → There is a maximum of ____ of nesting possible with subqueries.

          

  110. XML argument → Results of the query will be returned as an XML document.

          

  111. SELECT...INTO → Can be inherited from the schema permissions or CONTROL permissions on a table.

          

  112. AVG → Gives the lowest value in an expression

          

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

          

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

          

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

          

  116. FOR → Gives the exact number of selected rows

          

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

          

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

          

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

          

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

          

  121. CONTAINSTABLE → Used to delete all rows from a table without logging the individual row deletions.

          

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