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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






19. A function that returns the same value every time it is executed given the same input parameters






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






42. Provides security to dialogs connecting to remote databases.






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






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






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






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






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






48. A collection of conversations that are related






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






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