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






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






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






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






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






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






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






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






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






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






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






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






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






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






16. The word - phrase - or character string included as input in the full -text query.






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






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






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






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






21. A trigger that executes in response to a DDL event






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






37. Provides security to dialogs connecting to remote databases.






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






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






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






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






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






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






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






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






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






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






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






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






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