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. _______ designed to work with geometry and geography data types.






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






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






4. Actions an object can perform.






5. A process that finds word boundaries (tokenizes words) based on the linguistic rules for the data language specified; You can specify the language of the data in the column when creating a full-text index on a table.






6. A collection of conversations that are related






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






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






9. A database object that is used to manage stopwords; There is a system-defined stoplist and you can also create your own stoplists.






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






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






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






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






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






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






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






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






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






19. A function that returns the results as a table data type.






20. A function created as TSQL or as Common Language Runtime (CLR) code; TSQL ____s include scalar - multi statement table valued - and inline table-valued functions.






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






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






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






24. An agreement between two services that defines the message types the services send to accomplish certain tasks- It also defines what participants can send which message types






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






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






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






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






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






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






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






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






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






34. The word - phrase - or character string included as input in the full -text query.






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






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






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






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






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






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






41. A service that starts Fdhost:exe processes when the Full-Text Engine requires them.






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






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






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






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






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






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






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






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






50. A constraint that applies a Boolean expression to rows added or updated in tables to verify whether the update should be allowed