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 function that returns the results as a table data type.






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






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






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






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






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






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






8. A collection of conversations that are related






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






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






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






12. A set of code that is stored within a database; The ____ types supported by SQL Server are triggers - functions - views - and stored procedures.






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






29. The process of producing a particular instance of an object based on the object's properties and methods






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






50. Actions an object can perform.