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. An index that imposes a physical order on the rows within a table- There can only be a single clustered index on a table






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






18. Defines the name and contents of a message.






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






39. The process of producing a particular instance of an object based on the object's properties and methods






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






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






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






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






44. Sets the relative precedence for Service Broker conversations






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






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






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






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






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






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