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






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






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






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






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






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






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






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






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






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






11. Actions an object can perform.






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






13. Sets the relative precedence for Service Broker conversations






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






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






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






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. NET Framework applications that provide specialized functionality within SQL Server PowerShell






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






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






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






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






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






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






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






26. A role specified when enabling CDC that is used to limit access to the change data






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






28. A collection of conversations that are related






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






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






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






32. A process that finds word boundaries (tokenizes words) based on the linguistic rules for the data language specified; You can specify the language of the data in the column when creating a full-text index on a table.






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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