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 numeric value assigned to each connection to SQL Server.






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






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






4. NET Framework applications that provide specialized functionality within SQL Server PowerShell






5. A function created as TSQL or as Common Language Runtime (CLR) code; TSQL ____s include scalar - multi statement table valued - and inline table-valued functions.






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






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






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






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






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






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






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






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






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






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






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






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






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






19. Defines the name and contents of a message.






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






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






22. Provides security to dialogs connecting to remote databases.






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






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






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






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






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






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






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






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






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






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






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






34. A TSQL operator that combines the result sets from multiple queries.






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






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






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






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






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






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






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






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






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






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






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






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






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






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. Sets the relative precedence for Service Broker conversations






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