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






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






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






4. A _________ that might return a different value each time it is called given the same input parameter.






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






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






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






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






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






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






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






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






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






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






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






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






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. Defines the name and contents of a message.






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






37. Actions an object can perform.






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






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






40. Sets the relative precedence for Service Broker conversations






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






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






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 virtual object that represents a group of full-text indexes






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






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






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






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






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






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