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






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






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






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






5. A collection of conversations that are related






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






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






8. A database object that is used to manage stopwords; There is a system-defined stoplist and you can also create your own stoplists.






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






10. Sets the relative precedence for Service Broker conversations






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






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






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






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






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






16. Actions an object can perform.






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






44. Provides security to dialogs connecting to remote databases.






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






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






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






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






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






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