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 set of DDL events within the DDL event hierarchy






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






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






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






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






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






7. Sets the relative precedence for Service Broker conversations






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






29. A native SQL Sever data type that can handle both ____ fragments and documents as well as un typed and typed (schema validated) ___ data.






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






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






32. Defines the name and contents of a message.






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. The process of producing a particular instance of an object based on the object's properties and methods






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






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






37. A collection of conversations that are related






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






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






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






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






42. A word or character string defined by a word breaker.






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






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






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






46. A run time inside SQL Server that allows some objects to be created using a NET language such as C# or Visual Basic NET.






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






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






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






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