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. An index that imposes a physical order on the rows within a table- There can only be a single clustered index on a table






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






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






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






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






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






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






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






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






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






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






12. The process by which a user assumes the security credentials of another user






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






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






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






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






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






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






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






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






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






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






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






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






25. Defines the name and contents of a message.






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






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






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






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






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






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






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






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






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






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






36. Defines on which file group each ________ defined by a _______ function should be stored.






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






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






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






40. A TSQL operator that combines multiple related tables to define the result set; The _______ syntax defines a column or columns which are common between the tables that are used to correlate the data.






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






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






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






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






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






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






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






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






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