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. Defines where to deliver Service Broker messages. If not specified - the AutoCreatedLocal ¬¬¬¬¬¬¬¬_______ is used.






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






3. Sets the relative precedence for Service Broker conversations






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






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






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






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






8. Actions an object can perform.






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






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






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






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






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






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






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






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






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






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






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






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






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






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






23. Provides security to dialogs connecting to remote databases.






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






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






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






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






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






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






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






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






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






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






34. Defines the name and contents of a message.






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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