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 trigger that executes in response to a DML event






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






18. A process that provides inflectional matches to verbs and nouns based on the linguistic rules of the data language defined.






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






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






21. A collection of conversations that are related






22. Defines the name and contents of a message.






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






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






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






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






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






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






29. Provides security to dialogs connecting to remote databases.






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






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






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






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






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






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






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






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






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






39. Actions an object can perform.






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






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






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






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






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






45. A service that starts Fdhost:exe processes when the Full-Text Engine requires them.






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






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






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






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






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