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. Is well formed; that is - it must have a root node.






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






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






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






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






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






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






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






9. Actions an object can perform.






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






11. The smallest storage object maintained by SQL Server; a _____ is exactly 8 KB in size.






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






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






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






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






16. A long-term - asynchronous - and reliable communication channel across which messages are sent by using Service Broker






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






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






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






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






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






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






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






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






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






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






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






28. A query that is embedded within - but does not reference any columns from - an outer query.






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






30. During a transaction (before it is committed or rolled back) the data must remain in an isolated state and not be accessible to other transactions; In SQL Server - the isolation level can be controlled for each transaction






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






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






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






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






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






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






37. A collection of conversations that are related






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






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






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






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






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






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






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






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






46. Sets the relative precedence for Service Broker conversations






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






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






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






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