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. Defines an ending Log Sequence Number (LSN) to define a valid range of rows within a change table.






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






21. A function created as TSQL or as Common Language Runtime (CLR) code; TSQL ____s include scalar - multi statement table valued - and inline table-valued functions.






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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. Provides security to dialogs connecting to remote databases.






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






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






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






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






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






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






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






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






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