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. Provides security to dialogs connecting to remote databases.






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






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






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






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






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






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






8. A standard created by the OGC that is used to represent text-based descriptions of geospatial objects.






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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. Another name for an indexed view; Message Contains information that is sent within a Service Broker conversation.






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






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






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






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






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






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






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






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






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






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






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






43. An option that is available for views and functions that ensures any dependent objects cannot be dropped unless the view or function is dropped first.






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






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






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






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






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






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






50. A collection of conversations that are related