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. The smallest storage object maintained by SQL Server; a _____ is exactly 8 KB in size.






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






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






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






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






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






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






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






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






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






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






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






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






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






15. A _________ that is set on one or more columns in a table that ensures the data in each row is unique within the table for that column or combination of columns; A unique _________ allows NULL values and therefore cannot be used to uniquely identify






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






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






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






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






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






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






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






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






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






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






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






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






28. Actions an object can perform.






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






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






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






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






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






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






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






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






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






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






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






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






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






42. A collection of conversations that are related






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






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






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






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






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






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






49. Sets the relative precedence for Service Broker conversations






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






Can you answer 50 questions in 15 minutes?



Let me suggest you:

Browse all subjects

Browse all tests

Most popular tests



Major Subjects

Tests & Exams


AP
CLEP
DSST
GRE
SAT
GMAT

Browse all subjects

Browse all tests

Most popular tests