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






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






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






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






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






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






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






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






9. Actions an object can perform.






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






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






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






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 variable that is passed to a stored procedure or function.






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






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






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






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






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






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






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






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






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






24. Sets the relative precedence for Service Broker conversations






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






26. A specification by the World Wide Web Consortium for transmitting and storing semi structured data.






27. Defines the name and contents of a message.






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






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






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






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






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






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






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






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






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






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






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






39. Provides security to dialogs connecting to remote databases.






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






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






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






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






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






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






46. A collection of conversations that are related






47. A special case of a partitioned view where the member tables are stored on multiple SOL Server instances






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






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






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