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 reference ID associated with a specific model of the earth. These IDs reference the European Petroleum Survey Group (EPSG) standard identification system.






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






42. Defines an ending Log Sequence Number (LSN) to define a valid range of rows within a change table.






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






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






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






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






47. Sets the relative precedence for Service Broker conversations






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






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






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