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






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






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






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






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






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






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






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






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






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






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






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






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






14. Defines the name and contents of a message.






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






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






17. Provides security to dialogs connecting to remote databases.






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






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






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






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






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






23. A conversation between two specific Services - Broker services that provides exactly-once-in-order - (EOIO) message delivery






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






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






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






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






28. A server-side object that allows you to retrieve and process a set of data on a row-by-row basis






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






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






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






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






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






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






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






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






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






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






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






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






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






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






43. Sets the relative precedence for Service Broker conversations






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






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






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






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






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






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






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