Test your basic knowledge |

SQL Server Vocab

Subject : it-skills
Instructions:
  • Answer 50 questions in 15 minutes.
  • If you are not ready to take this test, you can study here.
  • Match each statement with the correct term.
  • Don't refresh. All questions and answers are randomly picked and ordered every time you load a test.

This is a study tool. The 3 wrong answers for each question are randomly chosen from answers to other questions. So, you might find at times the answers obvious, but you will see it re-enforces your understanding as you take the test each time.
1. A long-term - asynchronous - and reliable communication channel across which messages are sent by using Service Broker






2. A special case of a partitioned view where the member tables are stored on multiple SOL Server instances






3. NET Framework applications that provide specialized functionality within SQL Server PowerShell






4. A numeric value representing a physical location within a heap and page.






5. A TSQL operator that combines multiple related tables to define the result set; The _______ syntax defines a column or columns which are common between the tables that are used to correlate the data.






6. Actions an object can perform.






7. An object that is used to store a scalar value for use within a function - trigger - or stored procedure.






8. A process that provides inflectional matches to verbs and nouns based on the linguistic rules of the data language defined.






9. A rule applied to a column{s} within a table that is used to validate changes and ensure that data within a table does not violate business rules






10. A native SQL Sever data type that can handle both ____ fragments and documents as well as un typed and typed (schema validated) ___ data.






11. One column per table can be defined as its identity; The __________ property automatically generates a new increased or decreased number for the column when rows are inserted into the table






12. Is not well-formed; that is - it does not have a root node.






13. A conversation between two specific Services - Broker services that provides exactly-once-in-order - (EOIO) message delivery






14. Provides security to dialogs connecting to remote databases.






15. When two or more pieces of information are involved in a transaction - either all the pieces are committed or none of them are






16. A ____ that utilizes a UNION ALL clause to combine multiple member tables of the same structure into a single result set.






17. Used to store ellipsoidal (round-earth) data - such as latitude and longitude coordinates






18. A number assigned to entries within a transaction log to aid with recovery; lower bound Defines a starting ________ to define a valid range of rows within a change table.






19. A built-in or user-defined function that provides a calculation on a set of rows or values






20. A collection of properties and methods that provide a defined functionality.






21. A server-side object that allows you to retrieve and process a set of data on a row-by-row basis






22. After a transaction is committed - the final state of the data is still available even if the server fails or is restarted






23. A set of DDL events within the DDL event hierarchy






24. Tables within a database that store modified rows in a database with CDC enabled






25. A trigger that executes in response to a DDL event






26. A virtual object that represents a group of full-text indexes






27. An index that contains one or more columns in a table that are used to improve query efficiency; If the table has a ______ index - the root level of the _______ index points back to the clustering key - otherwise - the root level points to a row in






28. A physical structure implemented as a balanced tree that is used to speed up query operations






29. A hidden table where Service Broker messages are stored until they are processed.






30. A standard created by the OGC that is used to represent text-based descriptions of geospatial objects.






31. A reference ID associated with a specific model of the earth. These IDs reference the European Petroleum Survey Group (EPSG) standard identification system.






32. A table without a clustered index; (A ____ can still have nonclustered indexes defined on it)






33. XML files that define synonyms for terms in a specific language.






34. Used to configure SQL Server to send and receive messages over TCP/IP connections.






35. An object that contains significant words and their locations within the columns included in the index






36. A special type of __________ that has an anchor query - which is the source of the recursion - along with a UNION ALL statement and a second query - which recurses across the anchor query - and an outer query - which references the _____ and specifie






37. A TSQL operator that combines the result sets from multiple queries.






38. A part of the SQL Server process that manages full-text administrative tasks - handles full-text query execution - and manages the filter daemon host process






39. A process that manages third-party components such as filters - word breakers - and stemmers separated from the SQL Server process






40. The process of adding data to a full -text index either during creation or when the full-text index is built.






41. A function that defines the values that divide a table or index into multiple ___________.






42. _______ designed to work with geometry and geography data types.






43. A role specified when enabling CDC that is used to limit access to the change data






44. A ____ that includes only the rows that are in common in all tables referenced in the FROM clause






45. A set of code that is stored within a database; The ____ types supported by SQL Server are triggers - functions - views - and stored procedures.






46. Defines where to deliver Service Broker messages. If not specified - the AutoCreatedLocal ¬¬¬¬¬¬¬¬_______ is used.






47. A word that is commonly used and adds no meaning to a search - such as a - an - and the; _________s in SQL Server 2008 provide similar functionality to noise words in SQL Server 2005.






48. Defines on which file group each ________ defined by a _______ function should be stored.






49. The security credentials under which a code module is executed






50. A word or character string defined by a word breaker.