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 conversation between two specific Services - Broker services that provides exactly-once-in-order - (EOIO) message delivery






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






3. Actions an object can perform.






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






36. Provides security to dialogs connecting to remote databases.






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






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






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






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






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






42. Defines the name and contents of a message.






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






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






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






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






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






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






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






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