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 word or character string defined by a word breaker.






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






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






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






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






6. Defines the name and contents of a message.






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






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






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






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






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






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






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






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






15. Actions an object can perform.






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






33. A collection of conversations that are related






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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. After a transaction is committed - the final state of the data is still available even if the server fails or is restarted