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 query that is embedded within - but does not reference any columns from - an outer query.






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






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






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






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






6. Actions an object can perform.






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






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






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






10. Defines the name and contents of a message.






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






12. Provides security to dialogs connecting to remote databases.






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






36. A variable that is passed to a stored procedure or function.






37. Sets the relative precedence for Service Broker conversations






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






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






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






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






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






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






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






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






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






47. A set of DDL events within the DDL event hierarchy






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






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






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