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 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






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






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






4. A constraint that is set on one column or a combination of columns in a table that must uniquely identify a row in the table; By definition - the __________ cannot contain NULL values.






5. A ____ that includes all rows from an outer table and includes any rows from the inner table that match the _____ criteria.






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






7. A query that is embedded within - and references columns from - an outer query






8. Is well formed; that is - it must have a root node.






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






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






11. The process of producing a particular instance of an object based on the object's properties and methods






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






13. Another name for an indexed view; Message Contains information that is sent within a Service Broker conversation.






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






15. Actions an object can perform.






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






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






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






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






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






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






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






23. A deterministic view that has a unique - clustered _____ created against it






24. A specification by the World Wide Web Consortium for transmitting and storing semi structured data.






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






26. The name given to the group of tasks within a Service Broker solution that require messages to be sent.






27. A way to make SQL Server return a stream making up an XML document or fragment






28. Sets the relative precedence for Service Broker conversations






29. A function referenced in a SELECT clause that accepts an expression and returns a single value of a defined data type.






30. A property that can be applied to the varbinary(max) data type and that makes the actual data reside in a directory structure in the file system instead of inside the database's data file or files






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






32. A numeric value assigned to each connection to SQL Server.






33. A run time inside SQL Server that allows some objects to be created using a NET language such as C# or Visual Basic NET.






34. A named SQL statement programming object that can be called in either a SELECT or FROM clause that returns a single {scalar} value or a value with a table data type - but is not allowed to modify the state of a database or the instance






35. A _________ that is set on one or more columns in a table that ensures the data in each row is unique within the table for that column or combination of columns; A unique _________ allows NULL values and therefore cannot be used to uniquely identify






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






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






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






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






40. At the end of a transaction - either a new and valid form of the data exists or the data is returned to its original state- Returning data to its original state is part of the rollback functionality provided by SOL






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






42. A constraint that is used to implement referential integrity between tables (or even within a single table)






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






44. An internal metric used by SOL Server to determine the amount of processing resources a given query plan will consume






45. 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.






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






47. An international nonprofit organization that develops standards for geospatial and location-based services.






48. Defines the name and contents of a message.






49. An index that imposes a physical order on the rows within a table- There can only be a single clustered index on a table






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