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 table without a clustered index; (A ____ can still have nonclustered indexes defined on it)






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






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






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






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. The binary equivalent to WKT - which is sometimes used to transfer and store spatial data.






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






39. Provides security to dialogs connecting to remote databases.






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






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






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






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






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






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






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






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






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






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






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