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 table without a clustered index; (A ____ can still have nonclustered indexes defined on it)






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






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






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






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






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






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






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






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






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






11. The process by which a user assumes the security credentials of another user






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






13. Used to store planar data based on Euclidean space such as points - lines - and polygons






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






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






16. The binary equivalent to WKT - which is sometimes used to transfer and store spatial data.






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






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






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






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






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






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






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






24. A component that processes a document to extract the textual information from documents stored in a varbinary(max) or image column and then sends that information to the word breaker






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






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






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






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






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






30. An option that is available for views and functions that ensures any dependent objects cannot be dropped unless the view or function is dropped first.






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






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






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






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 query that is embedded within - and references columns from - an outer query






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






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






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






39. Actions an object can perform.






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






41. A variable that is passed to a stored procedure or function.






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






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






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






45. A module of code that is stored within a database that provides an API that applications can use to abstract the database structure from application code.






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






47. Sets the relative precedence for Service Broker conversations






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






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






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